Me.Detail.Visible=False does not suppress Detail

[Al Akers]

Being new to Access 2007, I am Trying to solve a bigger report problem, so I start simple with a Detail On Format Event of:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Detail.Visible = False
End Sub

The report detail is visable for all records! When this works I will build up to my desired filtering, but this simple event proceedure failes to suppress the detail area of my report. (I have set the report and page headers and footers to visible No on the property sheet, and that is working.) Thanks for pushing me past this puzzlement. -Al.

[evilbungle]

Hi Mate,

How are you firing the event? Might be that it is a new addition for 07, I am still using 03 but I am not sure when this event fires but it looks like the problem maybe that the event is not firing when you want it too.

[aakers]

Good morning EvilBungle,
I assumed that as I constructed my form in the Design View, that Property Sheet - Event - On Format allows me to create an event that is triggered when the report is tested on screen. But I am seeing that I must actually print or print preview the report for the filter to work. Thanks for getting me outside my box. I'm moving on to more complex filters now.

[NeoPa]

Hi Al.

If you sign in with your account your posts will not find themselves in the moderation queue automatically, and you can select EvilBungle's post as the Best Answer ;-)

[NeoPa]

I can see you tried to Al, but you set my post by mistake ( which certainly doesn't qualify). I've reset it for you so you can have another go at it. Click the Best Answer button/link within EvilBungle's post.

[Al Akers]

I’m also a bit new to participating in lists as a questioner. Thanks. –Al.

[NeoPa]

We all have to start somewhere Al.

Welcome to Bytes!