Access Rich-Text: Which subset of HTML is supported?
The following link lists ALL formatting options that are supported by Access (2007):
http://office.microsoft.com/en-us/access-help/insert-or-add-a-rich-text-field-HA010014097.aspx
In order to get a list of HTML tags, styles etc., I would suggest storing lines of text that have ALL formattings and then check its HTML (e.g. one record per each formatting option - total 16).
...I did it by myself and here is a list of supported HTML tags:
<div>,<font>,<strong>,<em>,<u>,<ol>,<ul>,<li>,<blockquote>
And, styles/attributes per tag:
<font>: face, size, color, style(with BACKGROUND-COLOR only)
<div>: align, dir
If you want an easy way to test combinations of tags, or see which tags Access is using for the rendering, you can create a simple "IDE" concept with a couple text boxes, and a few lines of VBA code.
The box on the left has the source, and the box on the right has the rendered HTML. When you change the text in either box, you see the changes live in both places. On the HTML side, you can use the toolbar to format your text as desired, then review the source on the left side to see which tags Access used.
To create this simple editor, use the following steps:
- Create a blank Microsoft Access form.
- Add two text boxes, naming them
txtSource
andtxtHTML
. - Set the
Text Format
of the right box toRich Text
. - On both boxes, set the
Enter Key Behavior
toNew Line in Field
. - Set both boxes to use
[Event Procedure]
for theOn Change
event.
On the VBA side, add the following lines of code to keep the text in sync:
Private Sub txtHTML_Change()
txtSource = txtHTML.Text
End Sub
Private Sub txtSource_Change()
txtHTML = txtSource.Text
End Sub
Hope that helps someone else out there! :-)
This is obviously an older topic, but there's information to add.
First, as far as I can tell, while BLOCKQUOTE is supported, I'm not sure that it can be created using the Rich Text GUI control. You can enter it in text that maps to a Rich Text control and it will be displayed differently (indented), though.
Second, while there's no Anchor/Link item in the GUI, if you type a URL into the Rich Text field, you will get a link as shown in the two examples below:
<a href="http://www.stackoverflow.com">http://www.stackoverflow.com</a>
<a href="mailto:[email protected]">mailto:[email protected]</a>
In both cases, I only typed the text between the start and end tags.
Third, there are additional HTML entities supported besides those mentioned above -- & for ampersand (&) and " for double quotation marks (").
I typed all of the special characters on a U.S. keyboard into a Rich Text control, and here's what I got:
<div>`~ ! @ # $ % ^ & * ( ) -_ = + [ { ] } \ | ; : ' " , < . > / ?</div>
Those make sense from an XML/HTML perspective.