Have a Report Image Show or Not

[mjones]

Hi Again,

I'd like to make an image (an embedded picture type) on a report not
show if a value in the table (which is a check box on the form) isn’t
checked. The fieldname is BringPMBOK and it is a data type Yes/No in
the tConf table.

Any ideas would be really appreciated.

Thanks!

Michele

 

[XPS350]

Make an "on format" event for the detail section in your report.

The code for the event is something like:

If me.BringPMBOK then
me.PictureFieldName.Visible = True
Else
me.PictureFieldName.Visible = False
Endif

(I did not test this)


Peter
http://access.xps350.com/

 

[mjones]

Make an "on format" event for the detail section in your report.

The code for the event is something like:

If me.BringPMBOK then
   me.PictureFieldName.Visible = True
Else
   me.PictureFieldName.Visible = False
Endif

(I did not test this)

Peterhttp://access.xps350.com/

Brilliant. Works perfectly. Thanks so much.