"G" <sk**@optusnet.com.au> wrote in message

news:3f***********************@news.optusnet.com.a u...

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..2147483647. 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

9999999999999999 so that users can only enter digits