Maximum value

  • Thread starter Thread starter Chi Huynh
  • Start date Start date
C

Chi Huynh

Hi,

I would like to know how to make the maximum value stand
out.

For example, In my summary report I have :

Call at first time: 2
Call at second time: 6
Call at third time: 3 and so on

I want to make the maximum value (6) has red or blue
color so that users can recognize it easily.

Thank You
 
Pre calculate the Max Value in the underlying Query

Then in the Reports OnPrint Event test to see if the value
equals the Max Value and set the Text Box Font Colour to
suit. Actually you will need to set the colour each time
so that is reset for other lines.
 
Back
Top