Access Memo field to Excel Textbox

A

ABM

I am trying to write an Access memo field into an Excel TextBox from the
drawing toolbar. For some reason if the memo field is over 255 characters
nothing will appear. I know a textbox will hold more than 255 characters. I
am trying to use 1 Excel template file to create spreadsheets that contain
data and 1 of 5 different comments. I thought I could just write the message
in a textbox by using this

oWorksheet.Shapes("TextBox").OLEFormat.Object.Text = rcd_Letters!LetterComment

Works as long as the comment is <= 255. Any ideas on how to write a
paragraph of variable text to Excel would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top