form/table not displaying zero

[jpsprack]

Hi all



I know this is pretty much a simple fix but for the life of me I cannot remember how to do it!

I have a 9 digit ID that is inputted on a form and stored in a table but the 0 keeps getting dropped.

I am using an input mask similar to another db but it is not working for this one

mask I am using is 000000000;0;_

So for ID's that start with 0 (EX:012345678) would display and stored as 12345678 instead

My brain is fried so any help is appreciated.

[JoeM]

It is usually best to store ID numbers as Text (String) and not Numeric. Then no leading zeroes will be dropped and you won't need to fool around with Custom Formats.

[jpsprack]

ugh.... thats what i did different... number not text.... sigh... always the little things
Thanks!