hide table design when no value (1 Viewer)

[Akai90]

hi

in report, how to hide table gridlines if no value

check the picture

thanks

 

[CJ_London]

is this a subreport? or listbox? something else?

If so, what is the sql that would populate it if there was anything?

 

[The_Doc_Man]

It is possible to have a section event that fires before printing; it might be possible to cancel the section so that the detail area (which IS a section)( would be skipped.

Format Event [Access 2003 VBA Language Reference]

learn.microsoft.com

 

[mike60smart]

hi

in report, how to hide table gridlines if no value

check the picture

View attachment 111088

thanks

Hi
If this is a SubReport and it has no data then you can hide it by going into the

OnNoData Event and use

Cancel = True

 

[Mike Krailo]

I wasn't even aware of that event for reports (On No Data). Thanks Mike.

 

[mike60smart]

I wasn't even aware of that event for reports (On No Data). Thanks Mike.

Hi Mike
Yes with Access we learn something new every day.