| | |
|
|
|
Help with Creating a Mask |
|---|
| message from Stephen White on 13 May 2004 |
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
|
| Stephen White replied to Stephen White on 13 May 2004 |
I tried this. It forces the correct amount of characters but Access doesn't automatically enter the zero's for the user.
|
| fredg replied to Stephen White on 14 May 2004 |
Set the mask to
999999
Then code the field's AfterUpdate event:
Me![FieldName] = Format([FieldName],"00-0000")
|
| mackei replied to Stephen White on 13 May 2004 |
i think so
sample mask based on sample
00-0000
hope this help
enter number with zero's in front to make every entry 6
digits
|
|
Archived message: Help with Creating a Mask (Microsoft Access)
