How to open an instance of Word in a form...

[paul]

I want to open an instance of Word in a form instead of a Text box with
"text" or "memo" datatype. The reason is that user can copy and paste large
amount of text and GRAHPICS to the Word window. And I want this Word
document stores as a link in the table to that record. Can it be done...if
so....how.....Thanks

 

[Lynn Trapp]

Have you considered using a hyperlink field in your table?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp

 

[Paul Mak]

Yes... but the problem is the "backend"....I have a SQL backend and SQL does
not have the hyperlink datatype.

 

[Lynn Trapp]

Then you might want to try using the Shell command to open an instance of
Word from a command button on your form.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp