Form Properties from a Table in Access97

What is the simplest way to make a property of a textbox (input box) in a form dependent on the value in a field in a table record.
Example: I want the background color of certain input boxes to be yellow when field entry is true in a corresponding field (say a yes/no field or checkbox).
Can the object property be made dependent on a field withou having to do an IF in code?