dreamer610
MIS
Hi,
I have an access report which I am trying to export to Microsoft Excel using the docmd.OutputTo command which I activate using a button on a form
The actual line of code is:
DoCmd.OutputTo acOutputReport, "rptActivity", acFormatXLS, , True
Now the report exports to excel, but the data in the cells is cut off if it is more than 256 characters. I can't figure out why this is happening, and how to correct it. Any help would be appreciated. Thanks in advance.
I have an access report which I am trying to export to Microsoft Excel using the docmd.OutputTo command which I activate using a button on a form
The actual line of code is:
DoCmd.OutputTo acOutputReport, "rptActivity", acFormatXLS, , True
Now the report exports to excel, but the data in the cells is cut off if it is more than 256 characters. I can't figure out why this is happening, and how to correct it. Any help would be appreciated. Thanks in advance.
