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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hiding and Showing Values in a Report

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I'm new to access and I am not even sure that this can be done. I want to divide a REPORT page into four (4) quadrants. The contents of a particular field will determine in which quadrant a graphic image and numeric value will be displayed. For example, if the quadrant field equals 1, I want a graphic image and a numeric value to be printed in the top left section of a page. Can it be done???
 
I'll assume you're putting your graphics etc. in to the report detail section.

In the Detail "On Format" Event add something like this:
Select Case Me.[TheNameOfYourControllingField]
Case 1 'or whatever value you are using
Me![NameOfImage1].visible = True
Me![NameOfImage2].visible = False
Me![NameOfImage3].visible = False
Me![NameOfImage4].visible = False
Case 2
Me![NameOfImage1].visible = False
Me![NameOfImage2].visible = True
Me![NameOfImage3].visible = False
Me![NameOfImage4].visible = False
'....and so on.....
End select
Gord
ghubbell@total.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top