Conditional Formatting not behaving as expected, from record to record (1 Viewer)

[123seven]

In frmOrders, single form view, I'm trying to format the billAddress and shipAddress to be different colours in the rare instances that they are not the same. Using conditional formatting, I thought this would work: [BillingAddressID]<>[DeliveryAddressID] resulting in a red background, which it does, but it persists through all records, including the majority that are the same.

I added a 2nd rule: [DeliveryAddressID]=[BillingAddressID] resulting in no background colour change, but this didn't make any difference.

Looking forward to some wisdom and thanks for reading.

 

[pbaldy]

I would expect to work. I assume you used Expression Is? Can you attach a db here that demonstrates the problem?

 

[Pat Hartman]

Which control are you attaching the conditional format to? If you want to color both, you need to add the rule to each control. You also need to account for null. values if they are possible.

 

[Gasman]

Continuous form? Unbound controls?

 

[cheekybuddha]

Can you post a screenshot of what you see?