I got it to work with this formula
(False=IsNull([SFirst])) And (True=IsNull([SBirthday]))
But I want to try yours as well. I am really getting into this formula stuff. thanks PBaldy!
Marian
I am trying to get the PBirthday field to highlight if the PFirst IsNotNull
PBirthday is a date field. I can get it to highlight on its own but having trouble getting it to highlight based on the value of the other field. Any ideas? Please? I tried the formula on the bottom but it did not work...
I am picking up Access after a bit of a break and using the 2019 version. I am interested in building my skills just for the fun of it. I am a geek and proud of it. Interested in all things computers. Hoping to pick up a few things and perhaps help out here and there.
Thanks for the welcome.
Marian