Highlight/color Whole Record When Condition is Met

[CDG via AccessMonster.com]

I am working on a database that is utilized in table/datasheet style. Once
one of the fields has been completed, I need the whole record (all the fields
for that record) to be highlighted (any color is fine). How can this be done?
Any help is much appreciated.

Thanks,
CDG

 

[Dale Fye]

I almost never work in datasheet view.

Have you tried using he conditional formatting? You would need to add a
field to the table (IsComplete - Yes/No). Which you would update to true
when all the required fields have been completed

Then create a conditional format for all of your data fields that evaluates
the expression [IsComplete] = True, and set the background color for those
records based on that field.

I tested this in 2007, and it works, cannot attest to how well it works in
previous versions.

 

[CDG via AccessMonster.com]

Dale,

Thanks so much for the suggestion. Instead of creating an extra field, I
used the last field in the record. Once this record is edited, then all
records should highlight. I used the Conditional Formatiing for each field:
[Name of last field] Is Not Null.

Thanks again,
CDG

I almost never work in datasheet view.

Have you tried using he conditional formatting? You would need to add a
field to the table (IsComplete - Yes/No). Which you would update to true
when all the required fields have been completed

Then create a conditional format for all of your data fields that evaluates
the expression [IsComplete] = True, and set the background color for those
records based on that field.

I tested this in 2007, and it works, cannot attest to how well it works in
previous versions.
----
HTH
Dale

I am working on a database that is utilized in table/datasheet style. Once
one of the fields has been completed, I need the whole record (all the fields

[quoted text clipped - 3 lines]

Thanks,
CDG