Number field question

[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.

 

[Gina Whipp]

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.

 

[Dave Eliot]

Data is entered on a form.
Setting the report field so it can grow did the trick.

Thanks.

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.