"G" <sk**@optusnet. com.au> wrote in message
news:3f******** *************** @news.optusnet. com.au...
I would like to restrict the number of digits in a number field in the
design of a table. eg. 16 digits maximum in a certain number field of a
table.
thanks.
You don't seem to be really talking about a "Number" field.
For instance, in the Table Design view of a table if you choose type
"Number", then the largest integer type available (shown in the bottom
section) is Long Integer which has the range
-2147483648..214 7483647. That is, less than 16 digits.
You probably want a "Text" field, of maximum length 16 characters.
Set up a text field with Field Size 16, and an Input Mask of
999999999999999 9 so that users can only enter digits