Report resolution problem with export.

[Guest]

Hello,

We have a custom program that is being used by clients with different screen
resolutions. We designed the reports with a resolution of 800 x 600, but
some of the clients are using 600 x 480. When the people that use the
640x480 resolution open the report, they can't see all of it. The report is
emailed to another workstation where the data is exported to excel or a rich
text document, but not all of the data is exporting. Some of the fields are
cut off on the report, (an example is if a field has 2000 lbs, but is cut off
so only 20 is showing, when the report is exported, the field now shows 20
instead of 2000 lbs). Has anyone ever had this happen, and does anyone have
any idea how to fix this problem? We are using access 2003.

 

[George Nicholson]

AFAIK, you are barking up the wrong tree.

The first thing I would do would be to check the print drivers and print
margins of the various workstations involved.

I could be wrong, but I've never seen screen resolution to have any effect
on report output, especially data being cut off the right.
I have seen a narrower print margin setting cause that, as well as the
difference in behaviour from one print driver to another. Report Output
driven by printers & their drivers, not screens.

AFAIK, Screens only display the "output" once the print drivers have
determined what that output will be. Screen resolution has no effect on the
report output itself.

HTH,

 

[Guest]

Thanks for the quick reply George,

We checked the print drivers and the margins, and that doesn't seem to be
the problem as the same drivers\printers are on some of the workstations that
are working and are not working. The only thing we noticed is only the
workstations that use a really low resolution are having this problem. Also
the field that is being cut off is in the middle of the report, if it was a
margin problem wouldn't the last field get cut off? After re-reading my
first post I wasn't fully clear, by saying they couldn't see everything, I
meant they couldn't see all of the data in one of the records (the example I
used before with the 200,000 only showing 20). For the export we are doing
it in code, I am not sure if this could be the problem either. Any other
suggestions would be great.

Andy

 

[Guest]

In code we are calling the docmd.sendobject function that converts a report
to an excel document. What appears to be happening is that the docmd does a
print preview of the report and uses data from that preview to populate the
excel file. When access is run a computer with a lower resolution, the data
in all the fields are truncated. So the problem we are having is when we run
this from access with a low resolution screen our data is getting truncated,
is there a way to force the docmd to not account for the monitors resolution.