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

Problem using long integer

100+
P: 167
I have a form that has the data source of a table. this table has a column called 'ABC' which I have defined as a long integer. I am using this column on my form as a datasource. However, when I enter the numbers 1,234,567,899 it takes the value okay. If I enter 2,234,567,899 it gives me a error message stating the "The value enterd isn't valid for this for this field". I read somewhere that you can use long integer for number -2billion to +2Billion.... since this is over 2 billion, is that my problem? If so, what can I use so I can display these large number?
Feb 24 '09 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 1,287
Yes, that large a number will not fit into the space access allocates for a Long Int. The Double has a larger range, since it allocates twice as much space to store the number. There are many options for displaying the numbers, like setting the format to Fixed and Decimal Places to 0, or using the FormatNumber Function.
Feb 24 '09 #2

FishVal
Expert 2.5K+
P: 2,653
since this is over 2 billion, is that my problem?
Yes, the problem is that you run over 32-bit of long integer type. If you take a time to read Access help, then you easily find exact range of long integer values.

what can I use so I can display these large number?
This depends on how large those numbers are supposed to be.
Feb 24 '09 #3

ADezii
Expert 5K+
P: 8,623
The MAXIMUM Value for a LONG INTEGER Field would be 2,147,483,647. This is beyond the Range of the Value that you entered.
Feb 26 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.