Field Size

[Maran]

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.

 

[John W. Vinson]

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.