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

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!

Thanks for the reply Shuff.

It works perfectly - the OnFormat property done the trick.

Thanks again,

Russell.