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
|
|||
|
|||
Conditional formatting
How do I use conditional formatting to change the fill color whenever the
field on a form has any data in it. What I mean is the fill color is grey when there is no data in the field, I already used conditional formatting to change the fill color to a darker shade of grey when the field has focus, what I also want to do is change the fill color to yellow after data has been entered. The three choices are field value is, field has focus, and Expression is. The field values are mostly different so I cannot use Field value is and specify a certain criteria every time. |
#2
|
|||
|
|||
Conditional formatting
Would a "Field value is" set to Not Null mean something was in the field?
Regards Jeff Boyce Office/Access MVP "terryh70" wrote in message ... How do I use conditional formatting to change the fill color whenever the field on a form has any data in it. What I mean is the fill color is grey when there is no data in the field, I already used conditional formatting to change the fill color to a darker shade of grey when the field has focus, what I also want to do is change the fill color to yellow after data has been entered. The three choices are field value is, field has focus, and Expression is. The field values are mostly different so I cannot use Field value is and specify a certain criteria every time. |
#3
|
|||
|
|||
Conditional formatting
That did not work, thanks for the help. I did find that i can use geater than
or equal to 1 for fields that contain numbers and greater than or equal to "A" for thos fields with letters worked. "Jeff Boyce" wrote: Would a "Field value is" set to Not Null mean something was in the field? Regards Jeff Boyce Office/Access MVP "terryh70" wrote in message ... How do I use conditional formatting to change the fill color whenever the field on a form has any data in it. What I mean is the fill color is grey when there is no data in the field, I already used conditional formatting to change the fill color to a darker shade of grey when the field has focus, what I also want to do is change the fill color to yellow after data has been entered. The three choices are field value is, field has focus, and Expression is. The field values are mostly different so I cannot use Field value is and specify a certain criteria every time. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting...cont. from 9/25 | Guenzak | General Discussion | 4 | September 26th, 2005 10:55 PM |
Conditional Formatting | sweetsue516 | General Discussion | 7 | September 20th, 2005 08:16 PM |
conditional formatting on a PivotTable? | confused | Charts and Charting | 0 | June 13th, 2005 04:15 PM |
Pivots and keeping conditional formatting | Jenn | General Discussion | 1 | August 11th, 2004 10:35 PM |
MIN value exclude '0' & Conditional Formatting | JEM | Worksheet Functions | 5 | April 16th, 2004 03:40 AM |