Leading Zeros

[spowers21]

I have read all of the posts in this forum concerning leading zeros. Several responses suggested putting a zero in the format of the text box for each placeholder needed. ex 00000 = 00123. I have tried that and it works for an unbound text box, but when I make the text box bound to my table it will not work. The field in the table is a text box and I have tried to use the same format in the table as in the form, but nothing seems to work. Please help!

 

[Pat Hartman]

The Format() function or control format that uses a string of zeros will only properly format a field defined as number.

Format(YourField,"000000")
will produce 000123 if YourField is numeric but
will produce 123 (right justified) if YourField is text.

 

[spowers21]

Thanks Pat! That helps.