By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,578 Members | 828 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,578 IT Pros & Developers. It's quick & easy.

Access - Report - Blank record and end of page code HELP! : )

P: n/a
I have an Access 2007 problem and I would just like to know if there
is some sort of solution out there. The problem is, when I build a
report that will 99% of the time be one page or less maybe even a
half
page. I end up with a giant space in the middle of my report. I
want
to fill that space with empty records but the records must only be
enough to fill the page and still leave the report foot at the bottom
of the last page. Those empty records in combination with the
gridlines surrounding the records will fill the blank space.
I was sure!!! I would find something in a forum
about
this situation, I searched extensively. I have even posted in
multiple forums and it seemingly has everyone stumped. I am linking
to a screenshot of a blank report to give you an idea of what I have
been dealing with. I will take any form of help possible, even if it
is go buy my book this book the answer is between page 1 and 1000 : )
I thought this would be something that would be very important to
certain types of reports and could be verrrrry helpful to the Access
Community.
With Respect,
Harley

Jan 4 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a

<ha***************@gmail.comwrote in message
news:b8**********************************@1g2000hs l.googlegroups.com...
I have an Access 2007 problem and I would just like to know if there
is some sort of solution out there. The problem is, when I build a
report that will 99% of the time be one page or less maybe even a
half
page. I end up with a giant space in the middle of my report. I
want
to fill that space with empty records but the records must only be
enough to fill the page and still leave the report foot at the bottom
of the last page. Those empty records in combination with the
gridlines surrounding the records will fill the blank space.
There's no link in your post. Do you have subreports by any chance? I have
the problem that if no records are entered for a category of staff then the
subreport will be empty and the report will look a bit odd. The report
footer will always be on the last page by it's nature.
Displaying empty records does sound a bit odd, unless you want a message to
appear stating the report returned null records.
Jan 4 '08 #2

P: n/a
"ha***************@gmail.com" <ha***************@gmail.comwrote:
>I have an Access 2007 problem and I would just like to know if there
is some sort of solution out there. The problem is, when I build a
report that will 99% of the time be one page or less maybe even a
half page. I end up with a giant space in the middle of my report. I
want >to fill that space with empty records but the records must only be
enough to fill the page and still leave the report foot at the bottom
of the last page.
Why put the report footer at the bottom of the last page? Why not just leave it at
the last line anywhere on the page?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Jan 6 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.