Input masks

[circles]

I have a form that will allow users to look up customer information by entering an ID number. All customer information is imported into the data base on a monthly basis and the customer ID numbers for some reason come with two leading zeros before the actual ID number. For example customer Jay's ID number would show up as 001234567. How can I have these two leading zeros sutomatically show in the ID field of my form so that users will only have to enter the actual 7 digit ID number?

thanks for your help.

 

[jebry]

Hi!

In the Before Update event procedure use this code:

txtID.Value = Format(txtID.Text,"000000000&quot

hth
Jeff Bridgham

 

[CosmoKramer]

If its only a lookup and the users are used to using a 7 digit number, set the criteria for customerID in your query to be something like:

"00" & [Forms]![frmMain]![txtCustomerID]

 

[circles]

Thanks for your help