number less than 1

[steve111]

hi

I am tying to put a number in a field
00001
but it keeps going to 1 how can I get 0001 in please

steve

 

[Mile-O]

Two ways:

1) You can make it a text field, and whatever you type will be stored.


2) You can ignore the fact that all the leading zeroes disappear and, when actually needed, format the field like so: Format([YourField], "00000")

Personally, I'd go with option 2.

 

[steve111]

I cannot have it as a text field
are you saying put this ([ncono],"0000)" in the form field ncono

steve

 

[Mile-O]

I cannot have it as a text field
are you saying put this ([ncono],"0000)" in the form field ncono

Keep it as a number field.

You only need Format it to 0000 when returning it in a query or binding it to a control on a form or report.

If you're entering directly into a table (heavens above!) then you can set the field's format property to 0000.

 

[steve111]

thank you
all ok