How make number entered in a form field start with a "0"

I have a form with a field and if the user enters a number <10, for example, then I want the number to appear with a zero in front of it.

For example:

If "3" is entered, make it appear as "03"

But if for example "12" is entered, leave it alone and let it be "12"
SteveL13Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Eric ShermanConnect With a Mentor Accountant/DeveloperCommented:
Then you can use the Before Update Event on your Form or Control to test the length of the data entered.  If 1 then add the 0 in front.

ET
0
 
Eric ShermanAccountant/DeveloperCommented:
Just set the Data Type to Text if that is an option for your field.

ET
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.