Row painting by condition

[EZLI]

Hi,
I have a subform (in DateSheet)on form.
If by condition in one field in Subform row
(DateDiff>=30) I need to paint in Yellow colour all that rows where this condition is true.
Thank's in advance,
Bob

 

[RoyVidar]

If you're using Access 2000+ versions, have a look at Conditional Formatting on the format menu. Hint, to use conditions on other controls than the selected, select "Expression is" in the droppdown, and enter the expression in the box to the right.

Perhaps post future form related questions in the Forms forum? (forum702)

Roy-Vidar

 

[EZLI]

Thank's Roy!
But the question was to paint the row not a field or column.
Bob

 

[RoyVidar]

Easily available in reports, but not in forms. Conditional formatting allows you to alter the format on all controls (except a few types, checkboxes, amongst others), so applying conditional formatting on all controls "paints" the whole row of a datasheet. And, as far as I know, this is the only way of "paining" a whole row in datasheets.

There's supposed to be some tricks working on previous versions (before conditional formatting became available), but they apply to continuous forms, and I've never used them, but see Colors and Continuous forms

Roy-Vidar