Form View - Highlight a Record

[CassandraB]

Hi All,

In my form view, is there a way to highlight (upon opening the form) only the records in my linked subform whos field option is only "YES"? (The one field asks 'further work needed?' - select 'yes or no' - I want the 'yesses' to be highlighted in the subform upon opening.)

I hope my question makes sense...............

Thanks for all past and present help!

 

[dcx693]

That all depends on how you want the records highlighted. You could use conditional formatting to draw attention to a field on your form (if you're using Access 2000+), but I don't know if there's a way to highlight an entire record. Even if there's no approved Access method, I'm sure some clever person here will have a workaround.

 

[CassandraB]

How about highlighting only the "YES" field only (not the entire record).

 

[CassandraB]

dcx693, conditional formatting worked. Thanks a million for your tip!