G
Guest
How do you format a phone field in a data access page to display a phone
number like (123) 456-7890 instead of 1234567890?
My underlying table and all my queries, forms and reports show the phone
numbers correctly. But, it doesn't display correctly in the data access page.
I've tried to change the (element) properties of the phone field to (000)
000-0000 and even tried making the properties the same as the original phone
field in the underlying table (i.e. I used the input mask with all the
exclamation points, semi-colons, nines etc.) All without success.
Thanks,
number like (123) 456-7890 instead of 1234567890?
My underlying table and all my queries, forms and reports show the phone
numbers correctly. But, it doesn't display correctly in the data access page.
I've tried to change the (element) properties of the phone field to (000)
000-0000 and even tried making the properties the same as the original phone
field in the underlying table (i.e. I used the input mask with all the
exclamation points, semi-colons, nines etc.) All without success.
Thanks,