A
Andym
Hello,
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 ex 640x480
, 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, or some other way to get by this problem?
Thanks,
Andy Mikkalson
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 ex 640x480
, 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, or some other way to get by this problem?
Thanks,
Andy Mikkalson