How to add leading zeros and REFRESH the screen after user tab (or move) out of the field

[path479]

Our database has a text field which the user is required to enter a numeric project id via a form. Most of the project id is less than 6 digits long, however we need to add leading zeros to ensure it is stored as 6 digits.

How do we add the leading zeros and, more importantly, REFRESH the screen so that the 6 digits long project id is reflected on screen/form as soon as the user tab (or click/move) out of the field in the form?



We have a separate "Save" button

[ranman256]

Format([field],"000000")
Or
string(6-len([field]),"0") & field([field])

[John_G]

Use the After Update event to change the value stored in the field:

me![field1] = Format([field1],"000000")

The display will be updated automatically.

[path479]

Thank you so much John_G and ranman256. Got it working now!

I am new to both Access and VBA. I had tried using the format command but I put it in wrong event. Alsod I used expression builder when I should have used code builder. This has been a valuable lesson.

Thank you again!