MS Access: HTML Editor control to use in forms

If you want to get HTML editor within MS Access form, there are couple of solutions available. The free solution I know is to get Not So Elegant HTML Editor. The problem with this editor is that

  • After looking at this editor, you will never say “so cool”
  • It is good for basic editing but many important functionality like “Table” editing is missing.

When I had to create HTML Editor within MS Access form, I asked the question to myself “Why to reinvent the wheel?” and the solution I came up with has the main benefits

  • It is completely FREE
  • When users will look at it, they will definitely say “so cooooool”.
  • Rich feature set
  • XHTML compliant code will be generated and hence output can be used anywhere.
  • Plugin based architecture can help add extra cool features

Here is a sample of how this editor would look likeAccess HTML Editor

The solution is to use readily available Web based HTML Editor like CKEditor, TinyMCE and embed them into MS Access forms. You can easily communicate between the Web based HTML editor and VBA code using VBA DOM manipulation functions available for Microsoft Web Browser ActiveX Control.


Download Sample MS Access Form

About Vishal Monpara

Vishal Monpara is a full stack Solution Developer/Architect with 13 years of experience primarily using Microsoft stack. He is currently working in Retail industry and moving 1's and 0's from geographically dispersed hard disks to geographically dispersed user leveraging geographically dispersed team members.

20 thoughts on “MS Access: HTML Editor control to use in forms

  1. Nickonice

    sorry, forgot to paste the text you should type under the DOCTYPE decleration:

  2. Nickonice

    For everyone who uses MS Access 2010, I did have the same problem and the solution is very easy.

    Edit the file ckeditor.html and put under the DOCTYPE declaration:

    That’s all, now it’s working again! The CKEditor editor is a great solution I think!

  3. POL

    Sorry but it doesnt work…

    function SetJavascriptData(…)

    v=wbeditor.document.parentwindow.execscript(FunctionName & “()”)

    End Function

    Access Denied

  4. aki

    Very useful info, I’ve adapted your code for MS Excel 2007 and it works fine!

    Thank you

  5. RobbL

    works beautifully however…

    how are you able to print to MS Access reports and have it understand some of the many available formatting options?

    Rich Text boxes linked to the Memo fields only understand a portion of the formatting?

    Is there an active x HTML control you can use on reports that works well in conjuction?

  6. Markus

    Thanks for sharing. The download link is not working. 🙁

Leave a Reply

Your email address will not be published. Required fields are marked *