Delete a grouping in an access report (1 Viewer)

zelarra821

Registered User.
Local time
Today, 14:08
Joined
Jan 14, 2019
Messages
88
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, 14:08
Joined
Jan 14, 2019
Messages
88
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
Local time
Today, 06:08
Joined
Oct 29, 2018
Messages
10,019

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom