Number Format

  • Thread starter Thread starter Montana Rain
  • Start date Start date
M

Montana Rain

Is there a way of entering a number, never to exceed 999, and have it
show in a form, table, & query as three digits - such as 056?
 
Is there a way of entering a number, never to exceed 999, and have it
show in a form, table, & query as three digits - such as 056?
Click to expand...

Set the format property of the field or a bound control to:
000
or you could use an unbound control on your form or report:
=Format([NumberField],"000")

As far as showing the value with 3 digits in a table, be aware that
tables are for storing data, not displaying it, so there should be no
real reason to care what the value display's as.
 
Back
Top