G
Guest
I have a continuous form in which users select machines and it brings over a
current price.
In the price table are a price date and a validity time in months.
I conditionally format the price control using an expression
DateAdd("m",[PriceValidityMonths],[PriceDate])>=Now()
to check the price is still valid; if not the price is coloured red.
In the form footer I sum all these prices and would like to know if there is
a way to have this conditionally formatted such that if any of the prices is
invalid, it's coloured red.
Any help/pointers gratefully received. I'm using Access 2000 and am pretty
much useless with it. Andy
current price.
In the price table are a price date and a validity time in months.
I conditionally format the price control using an expression
DateAdd("m",[PriceValidityMonths],[PriceDate])>=Now()
to check the price is still valid; if not the price is coloured red.
In the form footer I sum all these prices and would like to know if there is
a way to have this conditionally formatted such that if any of the prices is
invalid, it's coloured red.
Any help/pointers gratefully received. I'm using Access 2000 and am pretty
much useless with it. Andy