Conditional Formatting

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I have a form whose Recordsource is a query
that includes a numerical field signifying a
ranking value from 0 to 5 by .5. Correspondingly,
I have a set of images that pictorially represent
those rankings. (like we've all seen a million times
with the gold stars.) I was hoping that I could use
conditional formatting to invoke a function that
would change the picture property of an image
control as each record is formatted for display.

Somewhat to my surprise, Conditional
Formatting isn't available for image controls.
Any thoughts on how I could accomplish this
task on a continuous form?

Bill
 
You cannot do that in a continuous form in Access, without using a 3rd party
control.

The image control in Access 2007 has a Control Source for the first time, so
you can do it in the new version.
 
If you do literally want something like the five gold stars, you could
do this with text instead of graphics.

Include a field in your query something like ...

MyRating: String$([MyScore],"x")

This assumes that [MyScore] is a single digit or so number: if not,
just factor it as necessary.

You'll probably want to use some character other than 'x'; perhaps
something from the Wingdings font. And, of course, you may want to set
the fontcolour to something other than black.

One benefit of this approach is the absence of 'flashing' as the
conditional formatting is applied to each page of results.



Brian
 
Back
Top