Conditional Formatting not behaving as expected, from record to record

[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?

 

[Gasman]

Continuous form? Unbound controls?

 

[cheekybuddha]

Can you post a screenshot of what you see?