Input Mask properties

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

By default, a list box will not display the fields with
the Input
Mask properties. For instance, my Phone number field
displays
8001234567 instead of (800) 123-4567
How can I fix this?

Thanks
Joe
 
Joe said:
By default, a list box will not display the fields with
the Input
Mask properties. For instance, my Phone number field
displays
8001234567 instead of (800) 123-4567
How can I fix this?
Click to expand...

The list box is showing you what's really stored in the field. Base the
list box on a query that formats the phone-number field the way you
want. For example,

SELECT
Format(PhoneNumber, "(###) 000-0000") AS FmtPhone
FROM
MyTable;
 
Back
Top