Colors in reports

[desperatemeasures]

I want to make all the fields in the report background red, if 2 conditions are met, these 2 conditions are based on 2 fields in the report detail line.

 

[LittleSmudge]

First off :- There are no FIELDS in your "Report Detail Line"
Fields are in tables.
There may well be CONTROLS that are BOUND to fields - but that ain't the same thing.



If you are using A2k you can use the Conditional Formating option.
Format Menu .. .. Conditional Formatting ..


Otherwise in the Report.Detail's On_Format event you can evaluate the status of the two CONTROLS and then set the
Me.Detail.BackColor = (whatever number you need.}




'ope-that-'elps.


G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D

 

[desperatemeasures]

Thanks for the help, I cant use the conditional formatting option, as I need to base the colour on 2 CONTROLS.

I found a solution and its working now!

Thanks