rows on tabular forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stanley - 14 May 2007 02:44 GMT

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

Reply to this Message

missinglinq - 14 May 2007 04:11 GMT

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.

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message