View Single Post
Old 08-29-2019, 07:03 AM   #3
Suzi
Newly Registered User
 
Join Date: Aug 2019
Location: Durham, UK
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Suzi is on a distinguished road
Re: Conditional formatting of a report field based on outcome of two fields (Access 2

Quote:
Originally Posted by Gasman View Post
I have never used the table reference and field, always the control names.?

Code:
[Sum of Amount]>100
Thanks Gasman, Unfortunately the field aren't numerical; one is a true/false and the other is a text field. I simply need to know if the true/false is true AND the car reg field is blank that it highlights the field on the report to me to remind me to get the reg number.

It's probably the car reg value that's causing the expression to not work. How do we represent a null value in an expression?

Suzi is offline   Reply With Quote