Select the trainer's name field while in layout mode by right clicking it.
Select conditional formatting.
Add a new formatting expression and select the "formula" option.
Create a formula that checks the value in the status field to conrol whether or not the fill color of the field changes.
YourTable::Status = "Inactive"
would appear to be the conditional format expression that you would use.
That was it! It was the quotes that I was not including. It was driving me crazy!
Thanks for your help PhilModJunk!!!