Memo Field: Bullets, Numbers & Fonts

[Mark Jerde]

MS Office 2003, Visual Studio 2003.

I'm designing an Access database that will be used to generate Word
documents that will be incorporated into a larger document. I've done this
before. Access generated about 300 pages of this document. Open it only if
you need to read something boring to fall asleep. <g>
http://www.incits.org/tc_home/m1htm/2006docs/m1060169.pdf

I want to have numbers, bullets and different fonts in the Word document.
But Memo fields (IIRC) can contain only text. I could write my own tagging
handing, but is there a better way? Suggestions are appreciated.

Thanks.

-- Mark

 

[Douglas J. Steele]

You could store the data as RTF, and use an RTF control to display it.

 

[Cindy M -WordMVP-]

Hi Mark,

Short of using the Clipboard (copy/paste) or saving to a file and inserting
that, there's no way to directly port formatting from a database (RTF or HTML)
to a Word document. You'd have to convert the characters to "Word-speak"
one-by-one.

Since you're using Office 2003, I can suggest an alternative. Save the
information in Access as XML - more specifically, WordProcessingML. Or run a
transform on the Access RTF to obtain WordProcessingML. This can be inserted
programmatically directly into the Word document (InsertXML method) without
going over the Clipboard or an external file.

MS Office 2003, Visual Studio 2003.

I'm designing an Access database that will be used to generate Word
documents that will be incorporated into a larger document. I've done this
before. Access generated about 300 pages of this document. Open it only if
you need to read something boring to fall asleep. <g>
http://www.incits.org/tc_home/m1htm/2006docs/m1060169.pdf

I want to have numbers, bullets and different fonts in the Word document.
But Memo fields (IIRC) can contain only text. I could write my own tagging
handing, but is there a better way? Suggestions are appreciated.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Mark Jerde]

Cindy -- Thanks for your reply. I had not been able to find a way in either
VBA or .NET to tell Word from Access, "This is RTF text I'm sending you."

I will look into WordProcessingML and post back if I can't figure it out.

Thanks again.

-- Mark