Want to change colors of text items in reports

[Strangeone_99]

In a database I have a field with a drop down box that has 3 possible text
answers. When one of these answers is selected, I would like to have a
different color for each answer in the report. Example: Priority code with a
selection of 1, 2, 3. In the report I would like to have 1 as red, 2 as green
and 3 as blue. Is this possible and if so do I have to do this in code or
just within normal access functions

 

[MikeJohnB]

This is possible using conditional formatting on the reports control
[Priority code]

Select the control with your report in design mode and then select
conditional formatting.

Set Condition to "Field Value Is"
In the next box to the right select "equal to"
In the next box to the right enter "1"

No Quotes

Now select the backcolour Red

Now press the add button
Repeat the above for the second condition of 2

Press add again and repeat the above for the third condition of 3

You can also do the same with VB but it is mush easier using the conditional
formatting for up three conditions

Does this help???

Kindest Regards

Mike B

 

[MikeJohnB]

I will try sending this again.

Your requirement can be met using Conditional Formatting on the control
Priority Code with your report in design mode.

Select the Control Priority Code
Select Conditional Formatting
In the first box on the format menu set to

Field Value is

In the next box, select Equal to from the selction

Type 1 in the next box across to the right (Three Boxes to fill in)
Now select the back colour for the control, the text colour (red) and text
style from the selections available.

Now press the add button and repeat the above steps but enter the value 2 in
the rightmost box and set for the second colour

Press the add button for the third option and set the colour/font styles for
the third condition.

This is by far the easiest way for up to three options

I hope this helps?????

Kinedest regards

Mike B

 

[Strangeone_99]

Thanks man, It helps a lot, I'm a newbe to access and am starting to like
some of the stuff I see that it can do.