Printing Subform

[John Baker]

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

[MacDermott]

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

[John Baker]

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

[David B]

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

[Rick Brandt]

"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