Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

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?
0
cansevin
Asked:
cansevin
  • 3
  • 2
1 Solution
 
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
 
cansevinAuthor Commented:
Still not working... any other options?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)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 ...
0
 
Rey Obrero (Capricorn1)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:
Thanks! it worked with that box... now another box isn't open. I will ask a seperate question for it. Thanks again!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now