line spacing of memo field

[Michael Lei]

Hi All,
I am using the VBA command "print" to print memo field in a report.
How can I program the line spacing when I use the mentioned command.

Thanks a lot!

Michael

 

[John Spencer]

A text control in Access 2002 (and perhaps earlier) has a line spacing
property that can be set to control the spacing between lines.

The VBA print command prints to the immediate window (as in Debug.Print
The VBA Print # statement writes information to a file.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Michael Lei]

Dear John,
Thanks to your reply!
I still don't know how to set, soryy!
Could you tell me what command I can use to set the line spacing.
And I know how to set the font name and font size by using the following
command,

with rpt
..fontname="Arial"
..fontsize=10
end with
rpt.print

Thanks!

Michael

 

[Michael Lei]

thank you Stephen!

What I want is to print a memo field. How can I get one line from a memo
field? Thanks!