Large numbers in Access

cansevin
cansevin used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
FYI, it is an unbound field on the form. No way to change anything on the table.
Top Expert 2016

Commented:
try setting the Format property of the textbox to Standard or General Number

Author

Commented:
Still not working... any other options?
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems Analyst
Top Expert 2007

Commented:
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 ...
Top Expert 2016
Commented:
try using the afterUpdate event of the textbox

private sub textboxname_afterupdate()

me.textboxname=cstr(me.textboxname)

end sub


leave the format property of the textbox to BLANK

Author

Commented:
Thanks! it worked with that box... now another box isn't open. I will ask a seperate question for it. Thanks again!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial