Help with Creating a Mask

S

Stephen White

Is it possible to create a mask that will force a user to enter number with zero's in front to make every entry 6 digits

Ie
1 would be 00-0001
10 would be 00-0010
25 would be 00-0025
100 would be 00-0100
1000 would be 00-1000
 
M

mackei

i think so
if you want to force the user to key in all the numbers
including zeros...

sample mask based on sample

00-0000

hope this help
-----Original Message-----
Is it possible to create a mask that will force a user to
Click to expand...
enter number with zero's in front to make every entry 6
digits
 
S

Stephen White

I tried this. It forces the correct amount of characters but Access doesn't automatically enter the zero's for the user.
 
F

fredg

Is it possible to create a mask that will force a user to enter number with zero's in front to make every entry 6 digits

Ie
1 would be 00-0001
10 would be 00-0010
25 would be 00-0025
100 would be 00-0100
1000 would be 00-1000
Click to expand...

Set the mask to
999999
Then code the field's AfterUpdate event:
Me![FieldName] = Format([FieldName],"00-0000")
 
Top