By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Restricting no. of digits in field

P: n/a
G
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Whole number? Floating point? Negatives?

If you can cope with a whoe number or fixed point number, consider using a
field of type Decimal, with the Precision property set to 16.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

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

Nov 12 '05 #2

P: n/a
"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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.