Exporting Memo Field from Access to PowerPoint Using VBA

L

Louis

I have created a VBA procedure in MS Access 2003 that creates a PowerPoint
PPT from data in MS Access. However, whenever a field contains more than
255 or 256 characters, it displays garbage characters. The rest of the data
doesn't show.

If I copy the data from the Access Query and paste it into the powerpoint,
all the characters will display.

I use the following code for this action:
....
.Shapes.AddTextbox msoTextOrientationHorizontal, 0, 120, 360, 100
.Shapes(6).TextFrame.TextRange.Text =
CStr(rs.Fields("ProblemStatement").Value)
....

This is a really powerful tool, but if I can't get around this it will be
useless for me.

Thanks is advance.
 

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

Similar Threads

Exporting data from Access to Powerpoint 3
Convert PowerPoint Reference to late Binding 11
Change font size and colour in footer through VBA 4
Alternative to Access 2007 Memo Fields 14
Make Table Query Truncating Memo Field at 255 Characters 1
MEMO Field cut off on Form 3
EXPORT QUery with memo field to excel, truncated data 2
export access memo fileds to excel 1

Top