reports

H

He cries for help

Is it possible to take a form design into the report module by cutting and
pasting
or some other method? I have a incredible amount of time in this form design
and was planning on printing the form and not using the report format. What
would be the problem with this????
 
J

John W. Vinson

Is it possible to take a form design into the report module by cutting and
pasting
or some other method? I have a incredible amount of time in this form design
and was planning on printing the form and not using the report format. What
would be the problem with this????
Click to expand...

Open the Form in design view. Select File... Save As. Choose report.

The only problems would be that command buttons work on forms but not on
reports, and combo boxes and listboxes just display, and don't let you select.

John W. Vinson [MVP]
 
H

He cries for help

Thanks John, can you me tell the negative aspects of printing the form page?
I have done this before with no negative results?
 
K

Kari

I sympathize! I was in the same boat. If I remember correctly my problem
was that you can't e-mail forms as PDFs. I still don't understand why Access
won't let forms print or e-mail as easily as reports.

That said, I wanted to point out a glitch I ran into and spent a lot of time
trying to fix. I created a report (that looked just like my form) and life
was good. Except. . . . When I would close the report it would ask if I
wanted it to save. Even when I created a command button to close without
saving. I eventually tracked down the problem to a sub form on the report.
You can put a subform on a report, but apparently it does create its own
problems. After much experimenting, asking for help, and sacraficing of
virgins (well, maybe not that one) I gave in and changed it to a subreport.
I guess you can't fight City Hall. :-(

I hope this saves someone else a lot of blood, sweat and tears.

Kari
 
S

Steve Schapel

Kari,
... I still don't understand why Access
won't let forms print or e-mail as easily as reports.
Click to expand...

I guess the main point here is that forms and reports are different
sorts of objects, for different purposes. Forms are for the purpose of
entering and editing and manipulating data sets. Reports are for the
presentation of data. If you're trying to print stuff or email stuff,
it makes sense that the presentation modality has more functionality
than the data entry modality.

What you're saying here is like saying houses should be built so it is
just as easy to go through a window as it is to go through a doorway.
 
Top