Can't get memo field printed with exactly same layout as form

[BobA]

Trying to get a memo field to print out with exactly the same layout
as in the form. A client. requirement!

I removed the vertical scroll bar from the memo field in the form.
Then I copied the memo field from the form into the report. However,
when I print the report, the layout of the memo field is different -
more text is shown on a line than in the form.

suggestions?

Bob

 

[Marshall Barton]

Trying to get a memo field to print out with exactly the same layout
as in the form. A client. requirement!

I removed the vertical scroll bar from the memo field in the form.
Then I copied the memo field from the form into the report. However,
when I print the report, the layout of the memo field is different -
more text is shown on a line than in the form.

There is no guaranteed way to do that. Your best hope is to
make sure the form's text box and the report's text box have
the same Width, FontName, FontSize, etc.

Because of the vagaries of printers and the fact that
reports are aimed at the printer while forms are aimed at
the screen, the two device dependencies are different and so
the text rendering may be different. Even if you get it to
work on one machine, another user with a different printer
might get a different result.

If you tell your users that they must use {Ctrl}{Enter} when
they want a line break, I think you will have a better
chance of meeting the requirement.

 

[Rick Brandt]

Trying to get a memo field to print out with exactly the same layout
as in the form. A client. requirement!

I removed the vertical scroll bar from the memo field in the form.
Then I copied the memo field from the form into the report. However,
when I print the report, the layout of the memo field is different -
more text is shown on a line than in the form.

suggestions?

Relatively easy with a mono-spaced font like Courier. Otherwise no way to
do it reliably that I'm aware of.

 

[BobA]

Relatively easy with a mono-spaced font like Courier.  Otherwise no way to
do it reliably that I'm aware of.

Tried Courier without success.

Bob

 

[John Spencer]

You might try setting the form's Layout For Print property to True.
And making sure that the control on the report and the control on the
form are the same width.

Read the help on Layout for Print so you are aware of what happens.

Also, I assume the control on the form has its Enter Key Behavior set to
New Line In Field.

You will have to adjust the width of either the report control or the
form control to account for the width of the vertical scroll bar.

All that said, this is still no guarantee that what you see on the form
will exactly match what you see when you print a report.

This MAY be a situation where you will print the form. Depending on the
situation, you can programatically make changes to form when you print
the form (change the background of all the print sections to white or
transparent when printing, hide or show various labels and controls,
etc) and then restore the form to its original settings after printing.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================