Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

alternate colour in ms continous forms. 1

Status
Not open for further replies.

techkenny1

Technical User
Jan 23, 2009
182
AU
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


 
Have you tried this ?
1. [pd]=True
2. AltPrep()=True

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Hi PHV,
No I had not tried it in this order..
Many thanks, it works well
kp
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top