same report displays in 2003 but not in 2007

A few fields in my report display numbers up to 9,999,999.99. If I open the
report in Access 2003 it displays the number. If I open the same report
using Access 2007 it displays ###########.
For some reason this only started to happen around the first week of this
month. On 3-1-10, I have print outs of the report that displayed the numbers
properly using Access 2007. Then suddenly, all the fields began having this
problem. That is all fields displaying any 9 digit figures, as above.
I ideas?

Suggestions:

a) Widen the text boxes, so there's enough room to display all the digits.

b) Go to Office Button | Access Options | Current Database, and uncheck the
box for:
Check for truncated number fields.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"m galvin" wrote in message
...
A few fields in my report display numbers up to 9,999,999.99. If I open
the
report in Access 2003 it displays the number. If I open the same report
using Access 2007 it displays ###########.
For some reason this only started to happen around the first week of this
month. On 3-1-10, I have print outs of the report that displayed the
numbers
properly using Access 2007. Then suddenly, all the fields began having
this
problem. That is all fields displaying any 9 digit figures, as above.
I ideas?

Allen Browne has information on this setting at
http://www.allenbrowne.com/Access2007.html.

--
Duane Hookom
Microsoft Access MVP


"m galvin" wrote:

Duane,
How do I locate the "property in 2007 which can be
switched which defines the behaviour of text boxes that are too small to
display the full number"?

"Duane Hookom" wrote:

Access 2007 is not Access 2003. There is a property in 2007 which can be
switched which defines the behaviour of text boxes that are too small to
display the full number.

--
Duane Hookom
Microsoft Access MVP


"m galvin" wrote:

That I know. Question is why is the SAME report displaying differently in
Access 2003 and Access 2007. Why would I have to change the font and
control width in Access 2007 and not in Access 2003? And why would it
display properly one week and change the next week when nothing in the report
was changed: font size and control width?

"Duane Hookom" wrote:

Reduce the font size or increase the control width.



"m galvin" wrote in message
...
A few fields in my report display numbers up to 9,999,999.99. If I open
the
report in Access 2003 it displays the number. If I open the same report
using Access 2007 it displays ###########.
For some reason this only started to happen around the first week of this
month. On 3-1-10, I have print outs of the report that displayed the
numbers
properly using Access 2007. Then suddenly, all the fields began having
this
problem. That is all fields displaying any 9 digit figures, as above.
I ideas?