Link to home
Start Free TrialLog in
Avatar of cansevin
cansevin

asked on

Large numbers in Access

I am building something for my students that I would like to be able to handle very large number. It seems like if the number is about 20 digits, access simply rounds it. Is there a way to allow it to treat this large number normally?
Avatar of cansevin
cansevin

ASKER

FYI, it is an unbound field on the form. No way to change anything on the table.
Avatar of Rey Obrero (Capricorn1)
try setting the Format property of the textbox to Standard or General Number
Still not working... any other options?
Is the rounding occurring in the text box or table ?
Are you entering a decimal point or just an integer ?

I can enter N number of characters in an unbound text box with no rounding ...
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks! it worked with that box... now another box isn't open. I will ask a seperate question for it. Thanks again!