Need Leading Zeros On Form But Not On Table

[detrie]

Access 2003

I have a text box control bound to a text field

I need the value to look like this 00000014 (with the leading zeros) but stored without like this 14

The user may paste the entire value in or hand enter with or without the leading zeros

Regardless of the input method I need 8 characters to be seen on the form.

I tried entering 8 zeros 00000000 in the format property of the control but that only displays what I type (no leading zeros)

I've got this on the afterUpdate event. It formats correctly regardless of the input method (displays the leading values) but also stores them

    Me.ARReferenceID = Format(ARReferenceID, "00000000")

 

[bob fitz]

This link should be of help: http://www.access-programmers.co.uk/forums/showthread.php?t=113805