How do i keep a 0 in front of a number?

N

Naresh Nichani MVP

In a Form you can use the Format property of control.

For example you have field UnitCost and you always want to show 4 numbers
format it as 0000

Then number 12 shows up as 0012.

Regards,

Naresh Nichani
Microsoft Access MVP
 
Top