Conditional Formatting

[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?

I don't suppose there's some fancy font around
that would make this task extra trivial?

Bill

 

[Ron2006]

On Single form

1) Add label field
2) run font up to 14 or so or way bigger depending on what you want.
(try 22)
2.5) Play with the fonts available, but remember they have to be
available on ALL the machines that are running this app and that can
vary quite a bit if misture of OS.
3) Bold and color - probably red Or what ever you decide.
4) in the oncurrent event move 1, 2, etc "*" into the caption
depending on the grade.

If you make them really big you could also play with label width to
cover last part of if you allowed 2.5 stars......
(lower the number smaller the width.)

You could also use the graphic for all 5 and then use the label of an
option group with background NOT transpararent and change the start
and width for the lable to cover the number you want depending on
which side you want to be covered.

Ron

 

[Damon Heron]

Unfortunately, the continuous form is not ideal for this. What you can do,
though, is create a form header, and place your images there. Then in the
form's current event, have a Select case that makes the correct images
visible, based on the value of your ranking field.
As each record is entered the images will change to the desired ranking.
However, they wont be on the record, but at the top.

HTH
Damon

 

[Bill]

Damon,
It turns out that there are indeed fonts that contain
the characters that I would otherwise have to present
as images. Not the best, but certainly they will get the
job done in providing the necessary functionality.
Bill