Report not displaying correctly on a different computer

[pwdpwd via AccessMonster.com]

Hi

Not sure what is causing this. I have a quite complex report in Access 2007
that necessitates 53 columns, all next to each other; and with 53 fields in
the header showing the date 'vertically' in dd-mmm format.

On my Desktop and my Laptop they work fine - the Preview and Print options
all show the date clearly. I transferred the DB to a user's laptop - (they've
been using an earlier version in 97 and 2003 format for 9 years or so) and
the date just shows as #### in everyone of the 53 fields.

Thought at first that it was the vertical aspect of the field that was
throwing it out, but this is not the case; there is a Sum field in the footer
that also displays vertically, and this displays fine on my user's laptop.

Any help would be much appreciated.

 

[Marshall Barton]

Not sure what is causing this. I have a quite complex report in Access 2007
that necessitates 53 columns, all next to each other; and with 53 fields in
the header showing the date 'vertically' in dd-mmm format.

On my Desktop and my Laptop they work fine - the Preview and Print options
all show the date clearly. I transferred the DB to a user's laptop - (they've
been using an earlier version in 97 and 2003 format for 9 years or so) and
the date just shows as #### in everyone of the 53 fields.

Thought at first that it was the vertical aspect of the field that was
throwing it out, but this is not the case; there is a Sum field in the footer
that also displays vertically, and this displays fine on my user's laptop.

The #### means that the text box is not big enough to
display the date in the specified format.

If a user does not have the same font you are using, Windows
will try to use a "similar" font that may not fit.
Different printer drivers may display the same thing
slightly differently so that could be another reason why it
doesn't fit. It is almost always sufficient to just make
the trext box a little bigger.

 

[Duane Hookom]

Have you tried changing the format or size of the controls?

 

[pwdpwd via AccessMonster.com]

Hi - thanks for this - I'll try changing the size of the font and the control
and see if that sorts it

Have you tried changing the format or size of the controls?

Hi

[quoted text clipped - 12 lines]

Any help would be much appreciated.