Go Premium for a chance to win a PS4. Enter to Win

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

Large Number in Access

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.

Thanks!
0
cansevin
Asked:
cansevin
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
set the data type of the field to TEXT..

you are doing calculation... is the data in Currency format?
0
 
COACHMAN99Commented:
show1 = format(val(set1),"#0")
0
 
cansevinAuthor Commented:
Thanks coachman... where do I put that? After the formula on the button? Maybe after update event?
0
 
COACHMAN99Commented:
the click event of the second button
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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