You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
The other day I was working on a report where I wanted to build a sentence that included multiple fields from a record but I wanted to use rich text formatting to provide contrast. My scenario was pretty simple in that I wanted a bold title with a date trailing it. Some think like:
This was a great book, reviewed on 1/12/2007
My problem was both fields were pulled from normal text fields and I wanted the data to trail immediately after the variable length title.
Here is how I made it work inside Access.
For a number of reasons the rich text control doesn't support the full range of HTML but rather a limited subset of HTML focused around formatting text. If you stick to the list of HTML tags and attributes below you should be safe:
<font face="Arial Black" size=3 color="#A5A5A5" style="BACKGROUND-COLOR:#FFFF00"> <strong> <em> <u> <br> <div align=right dir=RTL> <blockquote> <ol> and <li> for number <ul> and <li> for bulleted lists
One gotcha you have to work around is handling quotes around attributes. Technically speaking all attributes in HTML should be surrounded by quotes. To have the string evaluate by the expression service to something that gets passed to the rich text control with the right syntax you need to use double quotes for any quote. In the example above <font color=""#A5A5A5""> will evaluate to <font color="#A5A5A5">. Alan Browne has published a good article for new users on Quotations marks within quotes.
Lastly, there is a quick way to generate the HTML you need and make sure it is compliant with the Rich Text control. Create a test table with one rich text control field on it. Create a simple form with two controls bound to the rich text field. Change one of the text boxes to Text Format = Plain Text. Now you can see the formatted version and the HTML.
Enjoy!
Comments: (6) Collapse
Hi Clint, I would find it very useful if the Access Team could put out a tool that allowed one to convert formatted text stored with the rich text format (FMS Total Access Memo or Stephen Leban's Rich Text Control) to the new HTML format used by Access 2007. Maybe also allow conversion in both directions as well.
Great idea. I think it is a great tool for someone in the community to build. The schedule for Access 14 is really full.
Tom...take all formatting syntax found here: search.cpan.org/.../Cookbook.pod and replace it with appropriate HTML tags. Should only take you a couple of weeks to do ;)
Oli - Sounds like a great first assignment for a bright young Computer Science graduate to tackle, if this person ends up taking a position with Microsoft.
I keep trying to get Oli to interview! He says he needs to graduate first. You know, our founder did pretty well without a degree.
I think it might be nice to have an HTML "RTF" box that actually supported all of HTML, and that came complete with support for data-bound AJAX controls. Or maybe support for MS Word lite in a lightweight RTF box. The current RTF/HTML box is so limited, why not just use the FMS control?
Comments: (loading) Collapse