I currently have large numbers in a database and when they get to a certain point it starts doing 5.253225E+12 which ends up taking up more room than if it just put the damn number.
Is there anyway to prevent Access from doing this to large numbers?
I've got the text box it's displaying in wide enough but it still does E+12, same in the table, no matter how far I stretch it, it will still display with 5.253999641391E+12.
It's a double (since it was long integer and it wasn't big enough for the number). I'm tacking on the day and date - Format(Date, "MMDD") onto an account number to differintiate the original account and the interest accumulated on it. So when I assign the interest an account number, it ends up looking like 525300064138. I was doing it on the fly instead of setting a variable to that value so I'm testing it again that way at the moment.
thats scientific notation, and TBH access has never converted any number in my system to SN, it happens quite a lot in excel but cant say Ive seen it happen in Access
Yeah, I've seen it before, but usually if you stretch the field it will correct itself to the original number but this doesn't seem to want to do that.
The 'E' is scientific notation, as previously said. It is equivalent to typing the number out completely, but you are getting that because the number in the field is VERY large.
All of these numbers are the same.
Code:
5.253225E+12
5.253225 x 10^12
5253225000000
You said you only want to display the account number, but what is that business about taking the date onto it? It sounds like that is your problem somehow. So this number, 525300064138, is that simply an account number, or did you tack something onto it? I don't see a date there anywhere.
Open the table and look at the account number. Is this number 525300064138 displayed in the table?
In the form, is the form displaying the value from the table/query, or are you manipulating data before you show the end user? If your manipulating it and displaying in an unbound field, could you show us your function?
edit- I just made a blank db and used your value 525300064138 as a double. The form had no trouble displaying it without notation. Also, I don't think you should be using a double for an account number. Long would suit you better. Do a search for Access number types. Here's what MS says.
Yeah, I got a little caught up in the whole notation issue. You should listen to Ken AME. While your account number is a number, you wont (or shouldn't be) doing any arithmetic with it, so just make it a text field. It's the same as a phone number or zip code. Those are also text fields.
