MS Access 2007 - Formating a Report dependent upon a value

[HumesRW]

Hello! I'm new to Access (esp. the 2007 version) and am trying to create a database for a social group to which I belong.

I have created a single database table with all relevent information (named Members, and am now beginning to create reports. One of the reports is for printing nametags. The nametag report is working fine, formatted to print 10 nametags on a single page, with two exceptions:
- I would like to display/hide a picture dependent upon a yes/no field in the database for that particular nametag. The yes/no field is named No_Pictures. I have already added the Image object and added the picture.
- I would like to toggle the color of the border of the particular nametag dependent upon a yes/no field in the database. The yes/no field is named SC.

Any assistance that anyone could offer would be GREATLY appreciated!

Thank You in advance!!!

 

[JoeMicro]

hi,

you could try conditional formating

or on yes/no_click event you could do

picture.visible=false

Joe

 

[HumesRW]

Thanks JoeMicro...

Unfortunately, Image and Box objects don't have conditional formatting available... Microsoft couldn't make is QUITE that easy. <GRIN>

I've tried writing On-Click events as you suggested, but they're not working... maybe I'm just too dense to write the Events properly.

Thank You for your suggestions though!

 

[SeeThru]

In a report, they need to be in th OnFormat section where the control is contained.

SeeThru
Synergy Connections Ltd - Telemarketing Services