I know how to do it in a report, but I'm not sure how to do it in a datasheet view of a form. Basically, lets say I have 2 fields, Status and Name. I want the Name to change to a different color (greyed out) if Status equals a certain value. On what property do I set the If statement that checks this? I only wish the property to be changed for that one record only.
I am using Access 2000. Thanks in advance.
I am using Access 2000. Thanks in advance.