Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Memo field to Excel Textbox
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Memo field to Excel Textbox
http://support.microsoft.com/default...;en-us;q213802 XL2000: How to Copy Text to Text Boxes Using the Characters Method http://support.microsoft.com/default...;en-us;Q213841 XL: Passed Strings Longer Than 255 Characters Are Truncated (xl 2000, 2002) do it 250 at a time using the characters method -- Regards, Tom Ogilvy "ABM" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Access to Excel memo-type field transfer | Excel Discussion (Misc queries) | |||
field shows (memo) not data | Excel Discussion (Misc queries) | |||
Export memo field in Access to Excel - data gets cut off | Excel Discussion (Misc queries) | |||
Memo Field Not pasting correctly in XL | Excel Discussion (Misc queries) | |||
Fill a Memo field | Excel Programming |