Form layout to report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that I spent hours setting up to be just like the one the
employees are used to, and I would like the report to look the same. is
there an easy way to create a report to be just like a pre built form? I
tried cut and paste, but I would have to set the "top" and "left" field of
each box.

Any help is greatly appreciated.
Ken
 
Ken said:
I have a form that I spent hours setting up to be just like the one
the employees are used to, and I would like the report to look the
same. is there an easy way to create a report to be just like a pre
built form? I tried cut and paste, but I would have to set the "top"
and "left" field of each box.

Any help is greatly appreciated.
Ken
Click to expand...

Right click the form in the db window and select "save as report"
 
Select all the controls on your form. While they are all selected, move the
cursor to the top-left most control right click and make a copy. Note the
positions on the side and top rulers. Gp to the report and do a paste. While
everything is still selected, place the cursor in the same position as you
had in the form and move evrything until you are in the same positions on
the rulers.
 
Back
Top