How to draw a line on report on blank space of page

G

Guest

My Boss has asked me a very typical solution, which I dont know whether it
can be solved or not. But what I have seen by VB Code every thing is possible.

Actually, I make a report and some time there are spaces left on the first
or other pages after printing the Data.

It depends on the number of Data printed after sorting.
Sometime there are 15 records and the balance of the space are left on the
first page, I want to draw a lines with the interval of space (the existing
Text control height). For example if there is 15 records then on the balance
spaces I want to draw 9 lines at the interval of space in height.
If more records then the number of lines will reduce.

The same if the records exceeds more than one page then the records moves to
second page, may be on the second page there are lot of spaces left. So there
will be more lines on the second page.

Please note that No additional pages is required to be added on report. The
need is only to fill the blank spaces with the lines on the last page of
Data.

It is required to make a good looks of the report, secondly, User can be
manually fill the records on the spare lines till the records is not updated
on computer and revised to print.

I tried to explain as much possible as I can. If still required more
explaination, please let me.

Requesting professionals to advise for the solution, or at least something
closer to it.

Regards.

Irshad.

---------------------
 
M

Marshall Barton

Irshad said:
My Boss has asked me a very typical solution, which I dont know whether it
can be solved or not. But what I have seen by VB Code every thing is possible.

Actually, I make a report and some time there are spaces left on the first
or other pages after printing the Data.

It depends on the number of Data printed after sorting.
Sometime there are 15 records and the balance of the space are left on the
first page, I want to draw a lines with the interval of space (the existing
Text control height). For example if there is 15 records then on the balance
spaces I want to draw 9 lines at the interval of space in height.
If more records then the number of lines will reduce.

The same if the records exceeds more than one page then the records moves to
second page, may be on the second page there are lot of spaces left. So there
will be more lines on the second page.

Please note that No additional pages is required to be added on report. The
need is only to fill the blank spaces with the lines on the last page of
Data.

It is required to make a good looks of the report, secondly, User can be
manually fill the records on the spare lines till the records is not updated
on computer and revised to print.


Take a look at the PrintLines sample at www.lebans.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top