By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,956 Members | 1,683 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,956 IT Pros & Developers. It's quick & easy.

Printing Subform

P: n/a
Hi:

I have a form, which contains a sub form (Employee main record and payment record). It all
shows up fine in a screen view, but when I come to print it I find that I cannot get the
sub form to print on the same page as the form. I have sized the whole thing, and in
theory it should fit into a single 8 1/2 x 11 page, but it just wont perform. I have the
sub sheet components set to "can shrink". Are there any special things that one should be
aware of when printing a form with a sub form, or do I just need to hack around and see
what will work?

Thanks and regards

John Baker
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
In general, printing from forms is "iffy".

For better results, create a report for printing.
Since you can save a form as a report, this isn't hard to do.

HTH
- Turtle

"John Baker" <Ba******@Verizon.net> wrote in message
news:le********************************@4ax.com...
Hi:

I have a form, which contains a sub form (Employee main record and payment record). It all shows up fine in a screen view, but when I come to print it I find that I cannot get the sub form to print on the same page as the form. I have sized the whole thing, and in theory it should fit into a single 8 1/2 x 11 page, but it just wont perform. I have the sub sheet components set to "can shrink". Are there any special things that one should be aware of when printing a form with a sub form, or do I just need to hack around and see what will work?

Thanks and regards

John Baker

Nov 12 '05 #2

P: n/a
Thanks:

I had no idea you could save a form as a report. How do you do it, and what are the
implications when the contents of the form are based on a query?

Thanks for the tip however.

Regards

John Baker

"MacDermott" <ma********@nospam.com> wrote:
In general, printing from forms is "iffy".

For better results, create a report for printing.
Since you can save a form as a report, this isn't hard to do.

HTH
- Turtle

"John Baker" <Ba******@Verizon.net> wrote in message
news:le********************************@4ax.com.. .
Hi:

I have a form, which contains a sub form (Employee main record and payment

record). It all
shows up fine in a screen view, but when I come to print it I find that I

cannot get the
sub form to print on the same page as the form. I have sized the whole

thing, and in
theory it should fit into a single 8 1/2 x 11 page, but it just wont

perform. I have the
sub sheet components set to "can shrink". Are there any special things

that one should be
aware of when printing a form with a sub form, or do I just need to hack

around and see
what will work?

Thanks and regards

John Baker


Nov 12 '05 #3

P: n/a
Why not just create a report which is based on the same query as your sub form ?
David B
John Baker <Ba******@Verizon.net> wrote in message
news:9d********************************@4ax.com...
Thanks:

I had no idea you could save a form as a report. How do you do it, and what are the implications when the contents of the form are based on a query?

Thanks for the tip however.

Regards

John Baker

"MacDermott" <ma********@nospam.com> wrote:
In general, printing from forms is "iffy".

For better results, create a report for printing.
Since you can save a form as a report, this isn't hard to do.

HTH
- Turtle

"John Baker" <Ba******@Verizon.net> wrote in message
news:le********************************@4ax.com.. .
Hi:

I have a form, which contains a sub form (Employee main record and payment

record). It all
shows up fine in a screen view, but when I come to print it I find that I

cannot get the
sub form to print on the same page as the form. I have sized the whole

thing, and in
theory it should fit into a single 8 1/2 x 11 page, but it just wont

perform. I have the
sub sheet components set to "can shrink". Are there any special things

that one should be
aware of when printing a form with a sub form, or do I just need to hack

around and see
what will work?

Thanks and regards

John Baker


Nov 12 '05 #4

P: n/a
"John Baker" <Ba******@Verizon.net> wrote in message
news:9d********************************@4ax.com...
Thanks:

I had no idea you could save a form as a report. How do you do it, and what are the implications when the contents of the form are based on a query?

Thanks for the tip however.


Right-Click the form in the db window and choose "Save as Report".

The biggest potential "gotcha" is that when you save a form as a report and that
form contains a subform you end up with a report that still has a subform
embedded in it. You need to save the subform as a report as well and then
change what the new parent report is pointing at.

When I first did this I opened the new report to tweak the design and then
double-clicked the sub and started changing that without realizing that I was
actually changing my original subform by doing so.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.