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?
cansevinAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor 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
0
 
cansevinAuthor Commented:
FYI, it is an unbound field on the form. No way to change anything on the table.
0
 
Rey Obrero (Capricorn1)Commented:
try setting the Format property of the textbox to Standard or General Number
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
cansevinAuthor Commented:
Still not working... any other options?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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 ...
0
 
cansevinAuthor Commented:
Thanks! it worked with that box... now another box isn't open. I will ask a seperate question for it. Thanks again!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.