A
alex
Color Report textbox
Hello,
Using Access ’03…
I’m trying to build a report with a little color…
I have a key that I keep in the Page Footer of the Report. It’s
pretty simple and looks like this:
1 to 5 = poor
5.1 to 10 = fair
10.1 to 15 = average
Etc…
I use colors to delineate the various ratings; e.g., poor is blue,
fair is yellow, etc., up to 6 ratings.
In the detail section of the Report are two textboxes that calculate a
person’s rating (number and text…e.g., 8 fair) by month. I’d like to
color the textbox(s) based on the key…
I cannot use conditional formatting because I have more than 4 colors…
I’ve tried this code in the On Print Event:
If [ControlName] = “pick value” then
Me.ControlName.BackColor = pick color
End if
It will color the textbox, but the textbox won’t requery when its
value changes…remember the report is by month and several months are
reported at a time!
My options seem to be limited; not sure if someone has some insight.
Thanks
alex
Hello,
Using Access ’03…
I’m trying to build a report with a little color…
I have a key that I keep in the Page Footer of the Report. It’s
pretty simple and looks like this:
1 to 5 = poor
5.1 to 10 = fair
10.1 to 15 = average
Etc…
I use colors to delineate the various ratings; e.g., poor is blue,
fair is yellow, etc., up to 6 ratings.
In the detail section of the Report are two textboxes that calculate a
person’s rating (number and text…e.g., 8 fair) by month. I’d like to
color the textbox(s) based on the key…
I cannot use conditional formatting because I have more than 4 colors…
I’ve tried this code in the On Print Event:
If [ControlName] = “pick value” then
Me.ControlName.BackColor = pick color
End if
It will color the textbox, but the textbox won’t requery when its
value changes…remember the report is by month and several months are
reported at a time!
My options seem to be limited; not sure if someone has some insight.
Thanks
alex