>Here's one that's stumping me. A report in an Access database returns 1 to multiple records. So if 3 records are returned there are x blank lines until the page footer begins and the report finishes. However, the user wants grid lines printed all the way down to the bottom of the page. Aside from using VBA to count the records and manually write these lines to the report, any ideas?
You could base the report on a UNION query that uses the current table or query and a temporary table created on the fly with the same structure and the necessary rows to fill the page being empty. This way if you use a line in the detail it will display all the way to the bottom. If you need vertical lines just set the borders of the controls to solid.
Simplistic I know, but it works and it doesn't use VBA.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only