[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

DoCmd.SendObject acFormatXLS dose not send all text contents?

Hi,
I am trying to send current form in exel format, but one field type in the form is memo which has a lot of data. When i click send, only half data of this field was sent away. How do i solve this problem? I would like to send all of the data in this feld.

Thanks a lot!
Alison
0
lzha022
Asked:
lzha022
1 Solution
 
leslynfCommented:
Alison,
Unfortunately, excel only allows 256 characters in any given cell. You will not be able to receive more than this in a cell. You could, however, send it to a text file, then copy and paste it as a text box into excel . . .

Food for thought.

Leslyn :)
0
 
lzha022Author Commented:
Leslyn,
Thanks for your answer.
I thought i have replied to your comment.

Cheers
Alison
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now