Hide member photos in a report

[russiver]

I have produced a report -Membership_Summary - from an underlying table which contains the following fields - Title (Mr, Master), Firstname, Surname and Photo (OLE object). The report works fine, but I would like to be able to not display the photos of members who's Title is set to (Master). In a form I can achieve this by setting the visible property to 'No' in a macro, but this will not work for a report. Any ideas please - can it be done in a query which I can then base the report on?

Many thanks

Russell

 

[shuff]

Whatever section the OLE photo is in, click on the section bar and then, the Event Tab. There is an OnFormat property there where you can assign a function or macro to run as the section is formatted. In this case, you would assign a macro with a Condition that if the title is "master" then SetValue olephoto.visible = no. That test would be applied for each and every record that gets formatted in the targeted section. I have used this technique to color or not color field text based on whether the person is a manager or not. Your scenario is similar, I think.

I think that will work, but I didn't have time to test it out before responding. Let me know if it does the job!

 

[russiver]

Thanks for the reply Shuff.

It works perfectly - the OnFormat property done the trick.

Thanks again,

Russell.