Start Free Trial
Log in
J G
asked on
zero pad a access form field
How do I zero pad a access form field?
ASKER CERTIFIED SOLUTION
Rey Obrero (Capricorn1)
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
How it works
Start Free Trial
Dale Fye
I don't particularly like to use input masks, but if you need to pad numeric values with leading zeros you will need to:
1. Make sure it is a text field.
2. Use the controls AfterUpdate event to add the padding, something like:
me.txtPadLeftWithZeros = Right("00000000" & me.txtPadLeftWithZeros, 8)
This way, the user doesn't need to initially add the leading zeros.
1. Make sure it is a text field.
2. Use the controls AfterUpdate event to add the padding, something like:
me.txtPadLeftWithZeros = Right("00000000" & me.txtPadLeftWithZeros, 8)
This way, the user doesn't need to initially add the leading zeros.