avalonwgi
asked on
Export data in a textbox on a form in Access to a word document
I have text data in a memo field that is displayed for a record. I need the ability to export the text data in the textbox on the form to a word document. I have seen other postings but mostly to merge or dump from a table.
You can merge into a word template using bookmarks in Word. Memo data sometimes truncates (will do so if emporting from a query, but work OK if exporting from a table) and I'm not sure what would happen from a form.
Essentially, you have a word template that you open using a background instance of Word, export the text to a bookmark that exists in the correct location on the template then save this as a doc file to a location & filename that you specify..
Is this what you're looking for?
Kelvin
Essentially, you have a word template that you open using a background instance of Word, export the text to a bookmark that exists in the correct location on the template then save this as a doc file to a location & filename that you specify..
Is this what you're looking for?
Kelvin
ASKER
Kelvinsparks,
That's not what I was hoping for. I was hoping that this was similar to just exporting to excel. I don't want to early bind, but I would like to late bind word application and then just dump the text to a new and empty word doc. Is that possible and if so, how? (inlcuding the binding)
That's not what I was hoping for. I was hoping that this was similar to just exporting to excel. I don't want to early bind, but I would like to late bind word application and then just dump the text to a new and empty word doc. Is that possible and if so, how? (inlcuding the binding)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So I can export the data, but it exports all field data on the form and not the specific fields that i want exported. Is there a way to do this and just as text?
ASKER
I got it to work with some minor changes. Thanks
ASKER