Help with page break

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

Hi to all and happy new year,

I have a very long form that need to be printed on a regular basis by the
user, the form is 21" long, I have set up 2 page break, one at 10.5" and the
other one at 21", all my margins are at .25" and the column height is set at
21".
When I print the form I always get a second page with a bar (background
color of the form) of approx .125", I have tried changing the position of
the first pagebreak to different positions but still getting the same
results, sometimes, without changing the position of my last control (memo),
I start seing the the bottom of that control on the second page
The third page is printing just fine, position wise, I even tried to lower
a little bit all the control of the bottom part of the form to see it it
might help but it is getting worse...

Does anyone have a solution to my problem on how to use properly the
pagebreak control ? I must be doing something wrong somewhere

Thanks

Alain
 
Forms are for displaying, editing and adding data. Not for
printing. Design a report base on the form that meets your
ouput requirements and reference the information on the form.

Chris
 
Hi Chris,

I know that too well my friend but the client does not want to issue a
report for that, since it will be printed not too often, the client prefer
to print directly from the form so......
I need to find a solution for that is possible

thanks
 
A report is not "issued". It is more a snapshot of the data at a particular
moment. Your client seems to think it is going to get stored somewhere, as
if it was a Word document. If you save your form as a report (File > Save
As) you can do the necessary formatting to the report. A command button on
the form can print the report.
If you are determined to print the form, name all of your controls according
to a naming convention (text box is txtName, combo box is cboDepartment, line
is linTopOfPage2, etc.). Try Google to find a complete listing of Access
naming conventions. When you are done with that, check the names listed in
the Object drop-down list on the Formatting toolbar, and identify ones that
you didn't name. There could be a stray control wandering around somewhere.
So, the form is printed "on a regular basis" but "not too often"? Hmmm.
 
Simply add a button to the form that the user can click to produce the
report. Why would they care if the form was printing, or the report? The
type of object used is not really an end-user issue.

Rick B
 
Back
Top