"11510" Displays "E+04"

I have a table in which the information in one field is always 11510, I have
a query based on that table, which, when run displays 11510, but when I run a
report based on that query, E+04 displays. When I export the report to
excel, it shows 11510 again, what is my problem?

Is the text box in the report wide enough to display all the characters? You
may also need to change the format to general or similar.

--
Duane Hookom
MS Access MVP

"LuhElle" wrote in message
...
I have a table in which the information in one field is always 11510, I
have
a query based on that table, which, when run displays 11510, but when I
run a
report based on that query, E+04 displays. When I export the report to
excel, it shows 11510 again, what is my problem?

Thanks for the idea, but I'm sure that the field is large enough. Actually I
solved my own problem (after quite a while) . It took a lot, you see, I'm
working with a linked DB, and I can't change the data type in the main
table... which was limiting my data types for the query and report. SO, I
used an input mask to simply show "99999". Thanks for the help.

"LuhElle" wrote:

I have a table in which the information in one field is always 11510, I have
a query based on that table, which, when run displays 11510, but when I run a
report based on that query, E+04 displays. When I export the report to
excel, it shows 11510 again, what is my problem?