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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|