HTML editing in Access?

[MrPink1138]

I'm using MS Access 2003 as a front end to a MS SQL2000 database which stores some press releases and some case studies for a website. User makes change to content using Access form - website updates. Pretty simple.

I'd like to be able to let the end user add some formatting to the text, i.e. bold tags or unordered lists. They can do this by entering in the HTML tags but most of the people using this don't know HTML... so my question is...

Does anyone know of any kind of plug-in, ActiveX control, etc., that would allow me to change an Access memo field into a WYSIWYG HTML editor?

I know of some that'll work within ASP or PHP which link to SQL but to make it as simple as possible for my users, and for security reasons, I don't want a web interface. I'd like to keep it all in MS Access.

Thanks for any help in advance.

 

[jrbarnett]

The easiest way I can think of is to have some sort of very simple tag language, then in the form, you do a replace of tags with the actual tag, for example they may enter:

$BThis is bold$/B
$IThis is italic$/I

You then use the Replace function to replace each item with the equivalent HTML tag. These could be listed in a table with the effect they have, so just loop through the table in a recordset and save the output to your usual place.
Doing a preview would be easy: just run it through the replace function, write a temp file out and open it in the default browser so that they can see what it would look like.
Using the table also makes it very extensible for future use, for example if you want to give them the ability to create tables or include references to CSS files.

John

 

[MrPink1138]

Hehe, if my users were smart enough to understand a tagging system I'd just teach them HTML. Sadly, that is not the case. I'm talking about people with extremely limited technical skills who'd need an MS Word style, "highlight text and click bold" kind of interface.

There are tons of WYSIWYG HTML editors out there. I feel like there has to be a way to use one of the inside Access.
I can't be the first person to try and do this.

Thanks for your comments though.