change the text color in the report

  • Thread starter Thread starter cdolphin88
  • Start date Start date
C

cdolphin88

Hi,

I have a report base on a query that will calculate the sum of the
percentage.

I need to change the color of the text according to my result.

If it's less then 100, I want to display it in red and if it's 100,
then display it in black.

How can I do that? Is it possible?

Cheers!


Claudi
 
Depending on your version of Access you should be able to use Conditional
Formatting. It's in the Format menu in design view.
 
I'm using Access 2002..
conditional formatting... how should I write the code? With the IIF??

Cheers!

Claudi
 
There are up to 3 conditions built in to the interface. Each is an IIf() so
you just enter your conditions and formats.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change text box background color depending on value in Label Reports 1
Question about VBA in the report 7
Dcount the values 0
Change text color in report 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
Percentage is incorrect in report footer 4
Hiding a #Num! occurrence in a report output 4
Change the Back Color automatically in a Report 1

Back
Top