allow user to highlight field on form

A

aussiebob

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
 
F

fredg

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

aussiebob

fredg said:
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.
 
F

fredg

fredg said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top