Display format of number field

[Sloaner]

I have a form displaying a number field called jobnum. How can I get the number to be a 3 digit number and thus always print as 001,002,003 etc.. up to 999
In the table the jobnum is defined as
Data Type = Number
Field size = Long Integer
Decimal places = Auto
Default = 0
Required = No
Indexed = No

 

[RoyVidar]

The controls format property: 000

Roy-Vidar

 

[Sloaner]

Thanks Roy, but this doesn't save the format in the table. I should've been more specific. I want the value to be saved as displayed on the screen. This worked on the screen but remains as a single digit in the table.

 

[RoyVidar]

Numbers are stored as numbers (without leading digits). Format is only a display thingie. If you want it stored as "007", convert the field to text.

Or apply the format to the table field too, which will give the same illusion in the tables datasheet view, as on the form.

Roy-Vidar