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

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

"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.

On Mon, 3 May 2010 23:06:01 -0700, aussiebob wrote:

> "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.

Sorry but I don't understand your form set-up nor your question.
The method I gave you will change the color of any or all controls
whose conditional formatting "expression is" refers to that check box.
If you don't want a control to have it's color changed, don't refer
it's conditional formatting to that check box.
You can have more than one check box to change formatting. Just refer
the control to the correct check box.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail