Help with number field

  • Thread starter Thread starter Dave Eliot
  • Start date Start date
D

Dave Eliot

In a table called Payments;
I have a field called CheckNumber.
Its data type is number
Its field size is Long Integer
Its format is General Number

Whenever the check number is more than 4 digits I get "1E+0" printed on the
receipt.

What am I overlooking?

Thanks for any help.
 
In a table called Payments;
I have a field called CheckNumber.
Its data type is number
Its field size is Long Integer
Its format is General Number

Whenever the check number is more than 4 digits I get "1E+0" printed on the
receipt.

What am I overlooking?
Click to expand...

This is scientific notation; Access will switch to it (sometimes futilely, as
in this case) when there isn't enough space in the textbox to display the
number. For example, a check number "10054" will be printed as "1.0054E+04",
abbreviated to 1E+04 - but even THAT isn't going to fit if there's only room
for four characters in the textbox.

Nudge the textbox a bit wider, or make the font a bit smaller, and you'll see
all five digits.

John W. Vinson [MVP]
 
Back
Top