Printing form the way it appears on screen

[Guest]

I have a 1 page form where one of the boxes contains more data than can fit
on one screen. Is there a way to force Access to print the data that is
currently on screen without resorting to the "CanGrow" feature? It's really
important that the form stay on 1 page.

 

[Douglas J. Steele]

Forms aren't really intended to be printed. That's what Reports are for.
Note that Access includes the ability to convert existing forms to reports
(without losing the form)

 

[Guest]

I would still love to be able to print the form without going to a report.

But since you mentioned the report, how do I convert a form to a report?

 

[Jeff Boyce]

Maybe I'm missing something...

You have a screen that can't show everything ("more data than can fit"), but
you want to print it, and expect to be able to print more than you can see?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

No,

I want to be able to print the form as it looks on the screen. For example,
that box that has all the data that doesn't fit on one screen... I want to be
able to scroll down to the data I want to see, then print the form just as it
appears with the data I want in view.

 

[Guest]

No,

I want to be able to print the form just the way it looks on the screen. For
example, this box that contains all the data that doesn't fit, I want to
scroll down to where that data is visable then print the form so that what is
on the screen gets printed. Right now, I can print the form but only the
first few lines of that box appear. I want to be able to print the form and
have the data that I want to appear be on the printed form.

Is that a better explanation?

 

[Douglas J. Steele]

Right click on the form, and choose "Save As Report"

 

[Rick Brandt]

No,

I want to be able to print the form just the way it looks on the
screen. For example, this box that contains all the data that doesn't
fit, I want to scroll down to where that data is visable then print
the form so that what is on the screen gets printed. Right now, I can
print the form but only the first few lines of that box appear. I
want to be able to print the form and have the data that I want to
appear be on the printed form.

Is that a better explanation?

You can set the CanGrow property of that TextBox to true and on the printout
the control will stretch vertically so you see all the text. I don't think
you can make it print "some" of the text unless it's the beginning rows.
You are not telling Access "print what is on my screen". You are telling it
"print this form".