Report truncating data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

In code we are calling the docmd.sendobject function to send a landscale
report
to an excel document. 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.
We are trying to find out what would cause this and what we could do to fix
this problem. 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, but are unsure if this is the cause or not.

Andy
 
Andy

?You're sending a report to Excel?

I assume you want the data to go to Excel. If so, send the underlying
query, rather than the report.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top