Input mask in source table not in form combo list?

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.
 
F

fredg

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove input mask format 4
Input Mask in tables 2
Input Mask - Date and Time 7
Extending Input Mask 4
Input Mask 1
Input Mask 3
How do I use the letter 'L' in an input mask? 1
Input Mask 1

Top