469,090 Members | 1,217 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

Custom report detail showing blank space

I'm fairly new at Access 2007, and I have a small problem. I created a custom report. How do I turn the detail section invisble (as in not showing any blank space) when they'nothing to show?
Sep 21 '11 #1
3 2329
Narender Sagar
189 100+
I think, you have created report directly from a table. You can create 1st a query from that table and in query design view, enter criteria as "Is Not Null". Then make custom report with that query.
If should solve your problem, otherwise give some more details of your database, preferably with some example.
Sep 21 '11 #2
3,079 Expert 2GB
I never experience this problem, as I make sure that there's a filled detail section. An empty report isn't appreciated by the user...
Just check before opening the report or rows are present, when they aren't show a pop-up message box with "No details selected"
Thus allowing the user to change the selection.

Sep 21 '11 #3
32,159 Expert Mod 16PB
Reports have a No Data event. If this is triggered then your code should close the report. This is fundamentally in tune with what Nico suggested.
Sep 26 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Buz | last post: by
2 posts views Thread by Amir | last post: by
2 posts views Thread by Bill Nguyen | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.