Input mask in source table not in form combo list? in Access Database General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
88lbr 1/20/2005 11:36 AM PST
  Question
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
fredg 1/20/2005 1:43 PM PST
  Answer
  On Thu, 20 Jan 2005 11:37:10 -0800, 88lbr wrote:

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

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
88lbr 1/21/2005 4:39 AM PST
   
  You nailed it. Thanks for the fix. I knew it was something simple I was
overlooking.

"fredg" wrote:

> On Thu, 20 Jan 2005 11:37:10 -0800, 88lbr wrote:
>
> > 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.
>
> --
> Fred
> Please only reply to this newsgroup.
> I do not reply to personal email.
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies