G
Guest
I have a form that when I print, the first few fields of the second record, prints on the bottom of form!!!! I can't have this...HELP PLEASE!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Albert D. Kallal
There is a LOT of problems when you try and print a form.
Really, as a developer the following is good advice:
Forms are for data input...they are very crappy for printing out data
Reports are great for printing data...but they are of no use for data
input!
So, lets use the right tools for the right job, and your life will be MUCH
easier.
So, create a nice looking report. You can even have nice things like date
and time, or a nice heading at the top. You can work on this report and make
it real slick...far nicer then printing a form.
Then, place a nice button on your form to print the one record you are
looking at. The code behind the button to do this looks like:
me.refresh
docmd.OpenReport "yourReport",acViewPreview,,"id = " & me.id
Really, as a developer the following is good advice:
Forms are for data input...they are very crappy for printing out data
Reports are great for printing data...but they are of no use for data
input!
So, lets use the right tools for the right job, and your life will be MUCH
easier.
So, create a nice looking report. You can even have nice things like date
and time, or a nice heading at the top. You can work on this report and make
it real slick...far nicer then printing a form.
Then, place a nice button on your form to print the one record you are
looking at. The code behind the button to do this looks like:
me.refresh
docmd.OpenReport "yourReport",acViewPreview,,"id = " & me.id