Example Apps for Businesses, Schools & Developers

Click any image to view a larger version

Version 1.1           Last Updated 1 Mar 2022                 Approx 0.5 MB


Long text (memo) fields in Access can use plain text or rich text.

TableDesign
Rich text is a subset of HTML allowing a variety of format effects.
The screenshot below shows a table with some examples of the possible outputs available with a rich text field.

TableData
However, not all HTML commands are supported in rich text

By comparison, a plain text field must have the same text format for all records in that field

Attached is a simple utility for creating rich text and viewing the corresponding rich text code.
It also uses the PlainText function to show a plain text version of the same data

Form
To format your rich text in the form (or table), select some text and the rich text mini toolbar pops up:

RichTextToolbar
The mini toolbar indicates the available formatting options:
•   Font name, size, style (bold/italic/underline), colour
•   Text highlight colour
•   Text alignment and indentation
•   Numbered or bulleted list
•   Direction of text entry (left to right or right to left)

NOTE:
You can also use the available formatting options from the ribbon or use keyboard shortcuts such as Ctrl+B (bold)

This is the form design and the underlying query

FormDesignQuery
NOTE:
a)   The code shown in the HTMLDetails column is just the rich text Details field displayed in a plain text format
b)   The PlainTextDetails column uses the PlainText function to strip out all the formatting code


Click to download:   Rich Text Example     Approx 0.5 MB(zipped)



NOTE: Rich text fields can only contain text (including hyperlinks)
If you want to include images / videos as well as text, you will need to use true HTML with a web browser control.

The following screenshots are from the help feature of one of my commercial apps, School Data Analyser
These show a rich text form (on the left) together with an HTML version of the same data (on the right).
Part of the corresponding code for each is shown below the screenshots.

RichTextHTML
As you would expect there are many similarities between the two sets of code.
The highlighted code is that used to display the image in the HTML version of the form

The screenshot below shows the editor used to create each type of form for that help system

SDAHelpEditor



Colin Riddington           Mendip Data Systems                 Last Updated 1 Mar 2022

Return to Example Databases Page Return to Top