techkenny1
Technical User
Hi all,
I have a question from thread 702-1377558.
This code provided by 'The Aceman1' works exremely well.
However on a form I require to change the line colour by condtional formatting.
So at present i have condtional formatting with 2 formats,
1. AltPrep()=True (from thread above)
2. [pd] =true (select different background colour from 1)
When the check box 'PD' is true the alternate colour will change to that condtion, but the line which uses the code as in 1 above stays constant.
How can have all lines change when 'PD' = true?
Its all on a continous form.
Many thanks,
kp
I have a question from thread 702-1377558.
This code provided by 'The Aceman1' works exremely well.
However on a form I require to change the line colour by condtional formatting.
So at present i have condtional formatting with 2 formats,
1. AltPrep()=True (from thread above)
2. [pd] =true (select different background colour from 1)
When the check box 'PD' is true the alternate colour will change to that condtion, but the line which uses the code as in 1 above stays constant.
How can have all lines change when 'PD' = true?
Its all on a continous form.
Many thanks,
kp