"fredg" wrote:

On Mon, 3 May 2010 16:52:01 -0700, aussiebob wrote:

I have a database which records info about disabled people. One form is used
to input comments about the the person and has several memo fields. The user
wants to be able to highlight a field if the information is important and
needs to be highlighted to other users of the system. I cannot use
conditional formatting because the decision to highlight the field is made by
the user depending on different circumstances.
Any help would be appreciated

Add a Yes/No Check Box field to the table.
Name it "Highlight".
Note: If a query is the form's record source you'll need to add it to
the query as well.
Include this new field on your form.
Select the Memo field.
Format + Conditional Formatting
Condition1
Expression is [highlight] = -1
Pick the color.
Save the changes

The user only needs to place a check in the check box and the memo
control will change color.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.
thanks for your very quick response Fred
i am not sure if i explained myself correctly but i have a question
The user might want to highlite several of the memo fields on the same form.
will the yes/no checkbox, when clicked, change all the conditionally
formatted memo fields ?. i need for previously changed memo fields to operate
independantly of each other.