Solved Delete a grouping in an access report (1 Viewer)

zelarra821

Registered User.
Local time
Today, 08:29
Joined
Jan 14, 2019
Messages
803
Hello, I have a report that I have structured as follows:

ScreenShot001.jpg


I would like to remove the grouping "Mes1" using VBA.

I have tried this code but it doesn't work:

Me.Section(0).Visible = False

Does anyone have any idea how I can get it? I could create another report, and have one for the annual reports, and another for the monthly reports, but if I can have it all in one, well, I save space.

Thank you.
 

zelarra821

Registered User.
Local time
Today, 08:29
Joined
Jan 14, 2019
Messages
803
i got it this way:

Reports("ReportName").GroupLevel(0).ControlSource = "Año"
Reports("ReportName").GroupLevel(1).ControlSource = "Estado"
Reports("ReportName").EncabezadoMes.Visible = False

you can check this article


Thanks a lot.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 00:29
Joined
Oct 29, 2018
Messages
21,358

Users who are viewing this thread

Top Bottom