Printing a different number of rows in a subform

[LaBelette]

Hi!

Here's my problem :

I have a form with a subform in it. The subform must have 4 rows when displayed on screen, but 10 when I print the form. Is there a way to do it?

 

[aphelps]

The only thing I can think of, and maybe this'll stimulate someone else to think of something better, would be to make a copy of your form that shows the ten rows you want to print. Then on your four-row-havin' form, put a button that opens this other form (it could say "Open printable version" or something). Then print that version. It's not perfect, but that way you can have your ten rows viewable on screen only for this "print" version.

Not knowing the details of the form, it's hard for me to say if this will work, and if it'll work, if it's acceptable to you.

Good luck.

 

[Rich]

Forms are not optimised for printing, use reports where you can output ten lines

 

[LaBelette]

Forms are not optimised for printing, use reports where you can output ten lines

Yeah, you're rigth, but try to explain that to my client!

 

[Pat Hartman]

Why does the client need to know that you are printing a form or a report. All he really cares about is what it looks like. The report will provide superior results when printed and that will ultimately make the client happy.

 

[LaBelette]

Why does the client need to know that you are printing a form or a report. All he really cares about is what it looks like. The report will provide superior results when printed and that will ultimately make the client happy.

Weel, this works when the client does not know Access, but this one knows it, and he don't want a report. I will prefer it, but he want a form.

I guess discussing about problems printing forms is just beating a dead horse. We knows it's useless, but...

 

[Pat Hartman]

Well, subforms DO NOT grow when you print a form. So, it will show what it will show and nothing more.