Creating a number of a set size

[Sara Overton]

I'm trying to display a number field as a set amount of numbers

I have numbers ie 10, 120, 4000
and would like them to display as
0010
0120
4000

Is this possible?

 

[Fornatian]

Try setting the format of the field to 0000.

Ian

 

[Sara Overton]

Thanks for the quick response

Any idea how I do that, sorry not up on this bit of VBA!

 

[charityg]

In table design view enter 0000 on the format line.