Hi everyone,
So before working on access, I had an excel file and did some clean up. A couple phone number fields were entered in a bunch of different ways but I made it where all the numbers are are stored as XXX-XXX-XXXX and put 000-000-0000 in any cells that were empty. When the user goes to fill out info, I put the input mask where phone numbers are entered to be phone number and looks like ###-###-#### and forces the user to enter phone numbers this way, however if there is no phone number provided I thought about making '000-000-0000' the default value, however it appears as 0-0-0 and shows up as 0 in the table whenever the record gets saved. I just wanted your thoughts on this. Should I set Required to Yes for this field and just have a label that says something like "input 000-000-0000 if no phone number is available"? or can I have it where it still appears as 000-000-0000 in the field automatically?
Thanks!
So before working on access, I had an excel file and did some clean up. A couple phone number fields were entered in a bunch of different ways but I made it where all the numbers are are stored as XXX-XXX-XXXX and put 000-000-0000 in any cells that were empty. When the user goes to fill out info, I put the input mask where phone numbers are entered to be phone number and looks like ###-###-#### and forces the user to enter phone numbers this way, however if there is no phone number provided I thought about making '000-000-0000' the default value, however it appears as 0-0-0 and shows up as 0 in the table whenever the record gets saved. I just wanted your thoughts on this. Should I set Required to Yes for this field and just have a label that says something like "input 000-000-0000 if no phone number is available"? or can I have it where it still appears as 000-000-0000 in the field automatically?
Thanks!
