Solved Field that starts with zero (1 Viewer)

[oxicottin]

I have a table field that has zeros as its first number, how do I get it to save the zeros?

 

[pbaldy]

It would have to be a text field rather than a numeric field. I might consider leaving it a number and formatting it with the leading zeros as appropriate.

 

[arnelgp]

you dont save it, instead on table design you can add Format property to add Leading zeros, eg:

Format: 0000

 

[oxicottin]

Thanks....

 

[Pat Hartman]

I strongly recommend that you NOT apply formats to data on tables. In the table you should be able to see the actual data. Format in a query or on forms and reports but NEVER apply formats on tables.