|
| 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
June 3rd, 2004, 12:06 AM
|
|||
|
|||
changing background color on continuous form
Third time is a charm! I had my computer's date wrong..here goes again geesh
I'm a dumbass...! Hi There! How can I have txtfield1 on a continous form change the background color to vbRed for that record only if txtfield3's value is "Yes" (this is a text field not a boolean) otherwise the background.color is white Thanks! Lurch 
|
|
#2
June 3rd, 2004, 12:33 PM
|
|||
|
|||
|
changing background color on continuous form
Use Conditional Formatting.
With the continuous form in design view, select the textbox. Then select Format ... Conditional Formatting The condition is: Field Value Is equal to "yes" Make sure you put the "Yes" in quotes. Then set the fill to the color red you want. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access "Lurch" wrote in message .. . Third time is a charm! I had my computer's date wrong..here goes again geesh I'm a dumbass...! Hi There! How can I have txtfield1 on a continous form change the background color to vbRed for that record only if txtfield3's value is "Yes" (this is a text field not a boolean) otherwise the background.color is white Thanks! Lurch
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
