Question - Input Masks on Forms and Tables
You just want to display the values that are already in a table?
Bind your form to a query that is based on your table. Add a calculated
field to the query that has this expression (or something similar):
DashPhone: Left([PhoneNumField], 3) & "-" & Mid([PhoneNumField], 3) &
"-" & Right([PhoneNumField], 4)
Then bind the textbox on the form to this field.
--
Hoping that this is helpful...
Ken Snell
<MS ACCESS MVP>
Quote:
> Specific to Phone Numbers: how do I display the dashes in the form
> without saving them in the table?
