Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Long Integer does not allow over 9 digit numbers. A way around?

Status
Not open for further replies.

Katya85S

Programmer
Jul 19, 2004
190
In access table i need a field that exceeds 9 digit numbers. And the field has to be a number-field, as the percentage will be calculated against this number.
When i'm entering an over-9-digit-number i receive an error message: the value you're entering isn't valid for this field. For example you may be entering a number that is larger then FieldSettings permits"
Is there a way around?

Thank you all in advance :)
 
Press F1 in field size in table design view :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top