Input mask in source table not in form combo list?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a input mask in a field in my source table for a combo box in a form.
The mask is not carrying over in combo list on new records. Old records
show the mask. Recently Access has shut down and created a backup. I have
not used the backup I am using my original. Is it possible my mdb. is
corrupt? Or am I not using the correct mask. What I want to show is this
in the form field. ex. 6-6666L. with a mask of A\-AAAAa. In the new records
the dash is dissapearing.
 
I have a input mask in a field in my source table for a combo box in a form.
The mask is not carrying over in combo list on new records. Old records
show the mask. Recently Access has shut down and created a backup. I have
not used the backup I am using my original. Is it possible my mdb. is
corrupt? Or am I not using the correct mask. What I want to show is this
in the form field. ex. 6-6666L. with a mask of A\-AAAAa. In the new records
the dash is dissapearing.
Click to expand...

The dash is disappearing because you haven't told Access to save the
mask with the data.
Change the mask to:
A\-AAAAa;0;
See Access help re:
InputMask property. Section 2.
 
Back
Top