rows on tabular forms

S

Stanley

I would like to change the color of a row or the properties of a field in a
row in a tablular form depending on a value in the row. I can do this with
reports. Is this posible in a form.
Thanks,
Stanley
 
M

missinglinq via AccessMonster.com

If you have Access 2000 or later it can be done using Conditional Formatting.
Click on the control to be formatted to select it, then goto Formatting >
Conditional Formatting.

If the formatting of the ControlA is dependant on a value of ControlA, use
"Field Value Is" then enter the conditions for formatting, then set the
ForeColor/BackColor/Bold/Italic/Underline/Enabled options for that condition .


If the formatting of ControlA is dependant on a condition of, for instance,
ControlB, use "Expression Is" and then, for example, ControlB > 5, or
ControlB = "Completed" and then, once again, set the
ForeColor/BackColor/Bold/Italic/Underline/Enabled options.
 
Top