asked on

Unable to render HTML superscript tag in Access 2010

Access 2010 is failing to render my HTML tags for superscripts and subscripts. I have set the containing text objects as Rich Text in both my form and my report. However, Access ignores the superscript (and subscript) HTML tags. Other HTML formatting such as bold and italics do render and display properly.

Here is an example:
This is an example of a superscript S for the letter H: H<sup>s</sup>.

By the way, the relevant field in the underlying table is a plain text memo field rather than a rich text memo field because I want to see the HTML tags in the table. I assume that's not the issue--because boldfacing works.

The subscripts/superscripts do render correctly when I export the text as an .html file and open it in my web browser.

If the superscripts were numeric, I could use the numeric superscript character codes, but I want to have superscript letters.

Can I get Access to display subscripts and superscripts in reports (and forms)?

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

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

Start Free Trial

Jeffrey Coachman

...and super/sub-script is not an option in the formatting section, so that says to me that this is not possible directly...

gordonwwaugh

ASKER

Thanks for the info. That's really disappointing. I might have to install the 3rd party TotalAccessMemo, which I do own. It uses Rich Text Format rather than HTML.

Jeffrey Coachman

OK, but make sure it supports sub and super script characters.

Also note that if if you do use a third party control, that you may always need this control to display this formatting.

This means that this utility may need to be installed on every PC that will need the formatting, ...including remote, mobile and external users...

JeffCoachman

gordonwwaugh

ASKER

Thanks for the reminders.

I have used TotalAccessMemo many times before, using other Access applications. It does support subscripts and superscripts. It uses a custom ActiveX control on forms and reports. It comes with an installation program that must be run on each user's PC. It's a bit of a pain when there are several remote users. That's why I switched to using Access 2010's built-in HTML rendering capabilities; it's just too bad Access has such limited support for HTML rendering.

Here's the web site for Total Access Memo.

http://www.fmsinc.com/MicrosoftAccess/RichTextMemo.html

Jeffrey Coachman

I am familiar with the fmsinc, but I had never used the rtf tool.

Perhaps in future versions of Access theses formats will be supported...

Good luck with this project.

;-)
JeffCoachman