Number Format

[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?

 

[fredg]

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?

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.

 

[KARL DEWEY]

In the table field properties set the validation to <1000 so it will
not exceed 999.