duluter
11-22-2008, 12:11 AM
Hi, all.
I'm using an Access 2003 database to store some commonly re-used text chunks for our business. I developed a Word macro that lets the user browse the entries in the database and insert the desired one into their document. Some of these re-usable text chunks must have the capability of being imported into the Word document with italics. The Access 2003 Memo data type does not allow rich text, so I devised some custom markup tags to wrap around the portions of text I want ultimately to be italicized. These tags are stored in-line with the text in the Memo field in Access. In my Word macro, I insert the text into the Word document, search the inserted text for these markup tags, replace what's between the tags with formatted text, and then delete the tags. This seems lame to me, but I'm not sure of another way. Aside from being cumbersome, it kind of makes the stored text in the Memo field unweildy-looking for regular users who might be browsing the database directly. I might also need to pull these text chunks and use them somewhere else, and these custom markup tags will travel with the text and not mean anything unless I'm always implementing some sort of function described above.
Is there a better way?
Thanks,
Duluter
I'm using an Access 2003 database to store some commonly re-used text chunks for our business. I developed a Word macro that lets the user browse the entries in the database and insert the desired one into their document. Some of these re-usable text chunks must have the capability of being imported into the Word document with italics. The Access 2003 Memo data type does not allow rich text, so I devised some custom markup tags to wrap around the portions of text I want ultimately to be italicized. These tags are stored in-line with the text in the Memo field in Access. In my Word macro, I insert the text into the Word document, search the inserted text for these markup tags, replace what's between the tags with formatted text, and then delete the tags. This seems lame to me, but I'm not sure of another way. Aside from being cumbersome, it kind of makes the stored text in the Memo field unweildy-looking for regular users who might be browsing the database directly. I might also need to pull these text chunks and use them somewhere else, and these custom markup tags will travel with the text and not mean anything unless I'm always implementing some sort of function described above.
Is there a better way?
Thanks,
Duluter