Hi, I have a textbox (say tbo1) in a form and what I want to do is this: If tableA.fieldA IsNot Null Then Make tbo1 background fill=Red and OnClick open Form2 What's the proper syntax in VBA? Thanks in advance!