Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conrolling Visibility on a Report

Status
Not open for further replies.

stgill

Instructor
Aug 6, 2003
11
AU
I wish to control which objects are visible on a report. My users will select an option from a list box on a form. This will enter a value from 1 to 5 that is stored in a table.

The report has 5 boxes drawn, all currently with the fillcolor set to white. I want to change the fillcolor to black depending on the selection made from the list box. For example, if the user selects the third option from the list, the third box on the form will change to black.

Any ideas appreciated.

Peter
 
Just play with the ListIndex property of your ListBox

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top