Color Code Madness

  • Thread starter Thread starter Julius
  • Start date Start date
J

Julius

I have a report where the 4th and 5th Column number should always match.
example column 4 is 10 count column 5 should be 10 count. I want to do this.
If column 4 is less than or greater than but not equal to column 5, then
color code column 5 red. Oh and this would be per row not per column. Is
this possible. Please advise. I need help on this like yesterday.
 
Hi Julius,

Very easy. Create an OnFormat event for your detail section. In the
code do your comparison and set the colors accordingly. It will be executed
individually for each and every row.

Hope this helps,

Clifford Bass
 
Recent versions of Access (since maybe 2000) support Conditional Formatting.
This should meet your needs.
 
Hi Duane,

Are you sure about that? Because if so, I would like to know how. I
do know that Excel supports conditional formatting. Were you perchance
thinking of Excel?

Thanks,

Clifford Bass
 
Thanks Duane,

I am so used to using the tool bar and the properties window that I
forgot about the menus. It is odd that it is not on the properties window.
Oh well.

Clifford Bass
 
Back
Top