Color Code Madness

[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.

 

[Clifford Bass]

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

 

[Duane Hookom]

Recent versions of Access (since maybe 2000) support Conditional Formatting.
This should meet your needs.

 

[Clifford Bass]

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

 

[Duane Hookom]

It's in the format menu.

 

[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