Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / February 2007

Tip: Looking for answers? Try searching our database.

Conditional Formatting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill - 19 Feb 2007 06:20 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.