add color in report depend on data value

[Dan Leveille]

I have an access database which has some data fields displaying a background
color in the text box that is dependent on the data value.

I.E. When the data is equal to "CRI" the text box on the report has a green
background. The color background is different with different data values.

How did the original Access Programmer do this? I would like to do it on new
reports.
--

 

[fredg]

I have an access database which has some data fields displaying a background
color in the text box that is dependent on the data value.

I.E. When the data is equal to "CRI" the text box on the report has a green
background. The color background is different with different data values.

How did the original Access Programmer do this? I would like to do it on new
reports.

Probably using conditional formatting.
Format + Conditional Formatting

Possibly using code.
Look in the Format event of whatever section of the report the
controls are in.

 

[Klatuu]

There are a couple of ways it could have been done. If the version of Access
it was done it is 2000 or > then it could be Conditional Formatting. You can
find that by opening the report in design view, selecting the text box, then
on the tool bar, select Format, Conditional Formatting.
The other possibility is that it was done using VBA. It would most likely
be in the On Format event of the section the control is in.

 

[Rick B]

The easiest way to do this is to use the built-in conditional formatting
feature. When in design-view, you can find it in the "Format" menu.

They could also have done is in code.

 

[Dan Leveille]

Thank You.

I tried it and it works. Truely helped me keep my project on track for
reports tomarrow.

)

/Dan/

 

[Ember]

This option only lets you identify three conditions, what if you have more?

Ember

The easiest way to do this is to use the built-in conditional formatting
feature. When in design-view, you can find it in the "Format" menu.

They could also have done is in code.