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
Allen Browne - 19 Feb 2007 07:35 GMT
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.

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>I have a form whose Recordsource is a query
> that includes a numerical field signifying a
[quoted text clipped - 12 lines]
>
> Bill
bdpearson@googlemail.com - 19 Feb 2007 15:29 GMT
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
,
> 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.