HTML content in cell

User avatar
ErikJan
BronzeLounger
Posts: 1254
Joined: 03 Feb 2010, 19:59
Location: Terneuzen, the Netherlands

HTML content in cell

Post by ErikJan »

I'd like to copy (and edit) HTML/Rich text in a cell. I can do that with a memo field but existing pictures in text (e.g. in Word) are NOT copied over, for that I need a separate field (OLE Object). Isn't there a way to copy text & pictures in one field??

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: HTML content in cell

Post by Rudi »

That is not possible in a database.
You will need to store each data type separately and attempt to concatenate them when you need them as output.

See this thread for vaguely possible workarounds...
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
HansV
Administrator
Posts: 78545
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: HTML content in cell

Post by HansV »

I'd probably be best to store the document in an OLE field and use its native application to edit it instead of trying to do so directly in Access.
Best wishes,
Hans