Number field question

  • 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.
 
Try...

Report? Set the field so it can grow.
Datasheet view? Widen the field
Form? Widen the field
Query? widen the field

If this database is to used by others AND you are entering check numbers via
the table you might want to consider using a form.
 
Data is entered on a form.
Setting the report field so it can grow did the trick.

Thanks.


Gina Whipp said:
Try...

Report? Set the field so it can grow.
Datasheet view? Widen the field
Form? Widen the field
Query? widen the field

If this database is to used by others AND you are entering check numbers
via the table you might want to consider using a form.
Click to expand...
 
Back
Top