Why do I get decimals instead of zeros?

[kgrift]

I try to type in a number such as 035287987 and access records the number as 35287987.

Why does this happen? I want it to record the leading zero and NOT include decimals at all.

I have the field formatted as text with a length of 9

Thanks

 

[BVerlaan]

The only thing I can think of is: the field you write to in the table is of type numeric. It's impossible to write leading zero's to a numeric field. Access probably translates your input (from a form?) to a valid long integer.

Do you have access to the table? If so, check the field type. change it to 'text'. If it's OK that you store these numbers as text with a leading zero.

Good luck, Bart Verlaan.