Form View - Highlight a Record

[mistereli]

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!

 

[TonyJollans]

Hi mistereli,

If you have Access 2K or above you should be able to do it with Conditional Formatting. It is nigh impossible in '97 and earlier.

Enjoy,
Tony

 

[mistereli]

Tony, conditional formatting worked! I had never heard of it until now. Thanks a million!!!!!!!!!!!!!!