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

Number Field Doesn't Show Number Right

P: 19
Hi all!
I am having trouble with number field in the table. When I enter 632674648064, it shows 6.32675E+11. The field type has to be number and I want the number to appear as 632674648064 as original. Does anyone can help with this error?
May 22 '07 #1
Share this Question
Share on Google+
2 Replies

puppydogbuddy
Expert 100+
P: 1,923
Hi all!
I am having trouble with number field in the table. When I enter 632674648064, it shows 6.32675E+11. The field type has to be number and I want the number to appear as 632674648064 as original. Does anyone can help with this error?
Place the table in design view and check the field's data type property (should be >>Number) and field size property>>>should be long integer
May 22 '07 #2

P: 19
puppydogbuddy,
Thank you very much for your reply!! I just figured out answer on my own… I struggled with it for a few hours… I am going to post here just in case someone has the same problem.

All I did was, I changed FieldSize to Double and Format to Fixed in the table design view. It solved my problem.
May 22 '07 #3

Post your reply

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