Auto Print Settings for Form

Hi guys,

I have a form with a couple memo fields in the body. The amount of text on
the form sometimes goes beyond the space allocated (need to scroll down in
the memo field to see all the text). I was wanting to put a control on the
form to print the current record, with the same format as the form, but it
only prints what is on the screen at that time (cutting off some of the text
that is in the lower part of the memo field) and it also prints portrait,
cutting off some of the form.

My two questions are..
1. Is there a way to print ALL text in the memo field even if one would need
to scroll down to see it all
2. Can you set default printer settings (more specifically landscape
instead of portrait) to a control button.

I haven't worked much with reports, but am open to anything that would solve
the problem.

Thank you.

Forms really are intended to be printed, so there's little print-related
functionality built into them.

You can convert your form to a report by right-clicking on it the database
window and chosing "Save as Report..." from the context menu. Go into the
report and make sure that the text boxes that contain the memo fields have
their CanGrow property set to True.

You can set Landscape vs. Portrait for the report by opening it in Design
mode, selecting File | Page Setup from the menu and looking on the Page tab.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Supynuts" wrote in message
...
Hi guys,

I have a form with a couple memo fields in the body. The amount of text
on
the form sometimes goes beyond the space allocated (need to scroll down in
the memo field to see all the text). I was wanting to put a control on
the
form to print the current record, with the same format as the form, but it
only prints what is on the screen at that time (cutting off some of the
text
that is in the lower part of the memo field) and it also prints portrait,
cutting off some of the form.

My two questions are..
1. Is there a way to print ALL text in the memo field even if one would
need
to scroll down to see it all
2. Can you set default printer settings (more specifically landscape
instead of portrait) to a control button.

I haven't worked much with reports, but am open to anything that would
solve
the problem.

Thank you.

Doug, I think you meant that forms are *not* really intended to be printed
g

Jeanette Cunningham

"Douglas J. Steele" wrote in message
...
Forms really are intended to be printed, so there's little print-related
functionality built into them.

You can convert your form to a report by right-clicking on it the database
window and chosing "Save as Report..." from the context menu. Go into the
report and make sure that the text boxes that contain the memo fields have
their CanGrow property set to True.

You can set Landscape vs. Portrait for the report by opening it in Design
mode, selecting File | Page Setup from the menu and looking on the Page
tab.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Supynuts" wrote in message
...
Hi guys,

I have a form with a couple memo fields in the body. The amount of text
on
the form sometimes goes beyond the space allocated (need to scroll down
in
the memo field to see all the text). I was wanting to put a control on
the
form to print the current record, with the same format as the form, but
it
only prints what is on the screen at that time (cutting off some of the
text
that is in the lower part of the memo field) and it also prints portrait,
cutting off some of the form.

My two questions are..
1. Is there a way to print ALL text in the memo field even if one would
need
to scroll down to see it all
2. Can you set default printer settings (more specifically landscape
instead of portrait) to a control button.

I haven't worked much with reports, but am open to anything that would
solve
the problem.

Thank you.

oops Sure did! Thanks, Jeanette!

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Jeanette Cunningham" wrote in message
...
Doug, I think you meant that forms are *not* really intended to be printed
g

Jeanette Cunningham

"Douglas J. Steele" wrote in message
...
Forms really are intended to be printed, so there's little print-related
functionality built into them.

You can convert your form to a report by right-clicking on it the
database window and chosing "Save as Report..." from the context menu. Go
into the report and make sure that the text boxes that contain the memo
fields have their CanGrow property set to True.

You can set Landscape vs. Portrait for the report by opening it in Design
mode, selecting File | Page Setup from the menu and looking on the Page
tab.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Supynuts" wrote in message
...
Hi guys,

I have a form with a couple memo fields in the body. The amount of text
on
the form sometimes goes beyond the space allocated (need to scroll down
in
the memo field to see all the text). I was wanting to put a control on
the
form to print the current record, with the same format as the form, but
it
only prints what is on the screen at that time (cutting off some of the
text
that is in the lower part of the memo field) and it also prints
portrait,
cutting off some of the form.

My two questions are..
1. Is there a way to print ALL text in the memo field even if one would
need
to scroll down to see it all
2. Can you set default printer settings (more specifically landscape
instead of portrait) to a control button.

I haven't worked much with reports, but am open to anything that would
solve
the problem.

Thank you.