Large Number in Access
Posted on 2014-03-05
I am working on a project for my math students that deals with every large numbers... some up to 20 digits.
They enter a large number in a field (titled raw1). I made that field accept large numbers by changing the type to BLANK and the following AfterUpdate code: Me.raw1 = CStr(Me.raw1).
That is working great (thanks Ray!).
I then hit a button that will do a simple calculation with the number in raw1. It stores that number in a field called set1. How can I format set1 so it also can hold large numbers? This field is the only one that is stored on a table.
Finally after the correct number is stored in set1 (an on the table). A 2nd button does a simple calculation and the result shows up on in a non-bound field called "show1". I need this field to be able to handle large numbers as well.