PDA

View Full Version : Solved: Acces Memo Field to Word Table



Carl A
09-20-2008, 06:17 PM
I have a Access database which has a memo field separated by VBCrlf. Using the split function I can extract the field as type variant however I'm at a loss as to how to insert this into a word table. I have used Bookmarks and cell routines in a attempt to populate the table but everything I've tried fails due to Error 13 Type Mismatch I understand the error variant to text doesn't work. I've tried CStr but that doesn't work either. This information from the memo field can range from 4 to 44 or greater. I've googled this to no avail. Any insight as how to accomplish this would be appreciated.

Oh by the way I know nothing about Word except how to populate bookmarks from Access recordsets fields

Carl A
09-22-2008, 05:27 PM
I resolved the issue: Alzheimers moment :blush