asked on

MS Access - possible to have HTML format field/form text box?

I've made an access database that sends emails out based on text entered on a form.
I have to put HTML coding in the text form field in order for the email to show any HTML formatting.

My question is, is there a way to get an Access text form control to show text in HTML format?

-Bill

ASKER CERTIFIED SOLUTION

Gustav Brock

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bill543

ASKER

Darn - I have Access 2007 at home, but my place of work is running 2003. I think I may try to link the Access 2003 form control to a word document to display the html text...

Gustav Brock

Or use the web browser control? I haven't used it but it should be able to display (net edit) an HTML note.

/gustav

Bill543

ASKER

Thanks for your inputs, guys. I went ahead and split the points evenly between you - hope you don't mind.

Gustav Brock

So you upgraded? Or?

/gustav

Bill543

ASKER

Actually the place I work probably won't upgrade anytime soon, and trying to email an OLE form object linked or embedded to a word document didn't work, and the web browser function seemed to be more for linking to webpages.

So I think what I'm going to do is just save the email body as an HTML file on the server and send using coding similar to this:
objMessage.CreateMHTMLBody "file://c|/temp/test.htm"

-Bill

Gustav Brock

Sounds like a good compromise.

/gustav

Gustav Brock

> the web browser function seemed to be more for linking to webpages.

It is. But if you have the content saved as an HTML file, you could open this.
However, a lot of work to do if it not even is absolutely needed.

/gustav