how to??

[cerealnumber]

hi there,

I have to be honest (i dont use acces frequent), so my question might have a very easy answer.

im trying to display numbers in a format like 000001, access however keeps setting it back to 1. Im trying to do this so when using the number for a query it doesnt end up displaying all matches starting with 1. How can i change this?

thanks in advance!

 

[pcEars]

Set the Format property to: 000000