Field won't display zero's

L

Lost Will

I am formating a field and it wont disply the zero's in my entry..
eg K000123 display's as K 123.

I have no idea how to change this and any help is appreciated.

I am in design view and select properties of the "cell" and edit what I need
there.
It shows me K000000;;_

thanks in advance,
will//
 
W

Wayne-I-M

Hi

Just an idea which may be wrong so.....

You may be trying to store this in a number formated field ???
Numbers do not start with 0 (unless a fraction eg. 0.00123)
If you want to show 000000123 then this is text not a number
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top