If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Field Size
Hello everyone.
\Im a new user to access. When i created a form an fill it with 12digits of number(exemple: 841214085712), the form it self change the format to somehing else like (8.4121408+E3). Anyone can teach me how to fix this problem. Thank u for ur concern. |
#2
|
|||
|
|||
Field Size
On Mon, 23 Feb 2009 21:35:01 -0800, Maran
wrote: Hello everyone. \Im a new user to access. When i created a form an fill it with 12digits of number(exemple: 841214085712), the form it self change the format to somehing else like (8.4121408+E3). Anyone can teach me how to fix this problem. Thank u for ur concern. Make the textbox bigger. It's going into scientific notation because there isn't room. THat said... if this "number" is actually an identifier, rather than something that you'll be using for addition, division, subtraction, multiplication or the like - use a Text field rather than any sort of number. The default Access Number datatype, Long Integer, is limited to the range from -2147483648 to +2147483647, so your number will overflow by a lot; if you use a Double you'll get roundoff error and may not be able to exactly represent your number. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|