A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

allow user to highlight field on form



 
 
Thread Tools Display Modes
  #1  
Old May 4th, 2010, 12:52 AM posted to microsoft.public.access.forms
aussiebob
external usenet poster
 
Posts: 6
Default allow user to highlight field on form

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
  #2  
Old May 4th, 2010, 01:41 AM posted to microsoft.public.access.forms
fredg
external usenet poster
 
Posts: 4,386
Default allow user to highlight field on form

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
  #3  
Old May 4th, 2010, 07:06 AM posted to microsoft.public.access.forms
aussiebob
external usenet poster
 
Posts: 6
Default allow user to highlight field on form



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

  #4  
Old May 4th, 2010, 05:44 PM posted to microsoft.public.access.forms
fredg
external usenet poster
 
Posts: 4,386
Default allow user to highlight field on form

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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.