Specific format of number

[zrzr]

Hi !

My problem can appear easy, but I'm working on it for two hours and I didn't find any solution...

I want to create a column in a table. This is a code, composed with exactly 5 numbers.

At the beggining, I used a numeric column, but if I do it, zeros are erased at beginning of code.And now, with a text one, I don't know how to check if all characters are numbers.

So, what should I do ???

 

[TSSTechie]

Hi
If you look in design view, in the bottom half of the screen you should put '00000' (without the quotes) in the 'Input Mask' box.
This should sort it for you