change the text color in the report

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
 
D

Duane Hookom

Depending on your version of Access you should be able to use Conditional
Formatting. It's in the Format menu in design view.
 
C

cdolphin88

I'm using Access 2002..
conditional formatting... how should I write the code? With the IIF??

Cheers!

Claudi
 
D

Duane Hookom

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
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 text color in report 2
Default text in date field 3

Top