If Control Value is Modified - Format background

[Micron]

and if it did, it will change ALL instances of the control to a red background. That is neither conditional formatting, nor is it the use of old value and current value properties.

[mike60smart]

Hi Colin

Thanks I missed that.

I changed Line 20 as follows and now the Control PO_Part_DueDate background colour on all records change ?

20    If Me.PO_Part_DueDate.OldValue <> Me.PO_Part_DueDate Then

[Welshgasman]

Put the compare of old value and value as an expression into the conditional formatting expression, and see what that produces.

[Welshgasman]

Just tested this in a continuous form and that worked?



My control was called ThirdParty

HTH

[mike60smart]

Hi Welshgasman & Micron

Many thanks that works.

[Micron]

Interesting. Thought of that but dismissed it thinking that the cf expression would not like the reference to the old value property. Alas, I had nothing to try it on.

[Welshgasman]

Interesting. Thought of that but dismissed it thinking that the cf expression would not like the reference to the old value property. Alas, I had nothing to try it on.

I only have one continuous form and I was not going to bugger that up , so I just took a copy and modified that.
I did try expression first with ThirdParty.Value <> ThirdParty.OldValue, but that did not work, so tried the above instead.

[mike60smart]

Many thanks
I learn something everyday.
Only problem being at my age (76) It becomes more and more difficult to remember everything.

[Welshgasman]

Many thanks
I learn something everyday.
Only problem being at my age (76) It becomes more and more difficult to remember everything.

That is why I use Google or look in my old databases. I'm 66 and can barely remember what I did 10 minutes ago, so I know how that is. Doesn't stop me from searching though.