Center memo field vertically

[John]

Is it possible to center a memo field value vertically? I use a memo field
for printing address labels and I would like the addresses to show up
centered vertically.
Thanks,
john

[salad]

John wrote:

Is it possible to center a memo field value vertically? I use a memo field
for printing address labels and I would like the addresses to show up
centered vertically.
Thanks,
john

At first I thought you meant to have it centered. not left justified.
Maybe you do. If so, click the field and set the justification as
centered (in the format tab of property sheet)

But that sounded ridiculous so I thought maybe you are concatenating the
address to the city to the state etc. If so, you should put in a nlcr
in it. Ex:
Me.MemoFld = Address1 & vbNewLine & Address2 & vbNewLine & City...

[John]

"salad" <oi*@vinegar.comschreef in bericht
news:4h*****************@newsread2.news.pas.earthl ink.net...

John wrote:

>Is it possible to center a memo field value vertically? I use a memo
field for printing address labels and I would like the addresses to show
up centered vertically.
Thanks,
john

At first I thought you meant to have it centered. not left justified.
Maybe you do. If so, click the field and set the justification as
centered (in the format tab of property sheet)

But that sounded ridiculous so I thought maybe you are concatenating the
address to the city to the state etc. If so, you should put in a nlcr in
it. Ex:
Me.MemoFld = Address1 & vbNewLine & Address2 & vbNewLine & City...

Thanks. My address memo field value can take 4 to 7 lines, depending on
whether a department and subdepartment are included. If it's 4 lines then
the lower part of the label is white. I think I will fiddle with adding an
extra line at the start in that case so that the value seems centered
vertically.
john

[Stephen Lebans]

See:
http://www.lebans.com/verticaljustification.htm
VerticalJustificationA2K.zip is a database containing a function to allow
for vertical centering of the contents of a Label or TextBox control. Works
with both Forms and Reports.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"John" <[e-mail] in message
news:er***********@textnews.wanadoo.nl...

"salad" <oi*@vinegar.comschreef in bericht
news:4h*****************@newsread2.news.pas.earthl ink.net...

>John wrote:

>>Is it possible to center a memo field value vertically? I use a memo
field for printing address labels and I would like the addresses to show
up centered vertically.
Thanks,
john

At first I thought you meant to have it centered. not left justified.
Maybe you do. If so, click the field and set the justification as
centered (in the format tab of property sheet)

But that sounded ridiculous so I thought maybe you are concatenating the
address to the city to the state etc. If so, you should put in a nlcr in
it. Ex:
Me.MemoFld = Address1 & vbNewLine & Address2 & vbNewLine & City...

Thanks. My address memo field value can take 4 to 7 lines, depending on
whether a department and subdepartment are included. If it's 4 lines then
the lower part of the label is white. I think I will fiddle with adding an
extra line at the start in that case so that the value seems centered
vertically.
john

[John]

Thanks. Works great!
john

"Stephen Lebans" <[e-mail]>
schreef in bericht news:Md*****************@ursa-nb00s0.nbnet.nb.ca...

See:
http://www.lebans.com/verticaljustification.htm
VerticalJustificationA2K.zip is a database containing a function to allow
for vertical centering of the contents of a Label or TextBox control.
Works with both Forms and Reports.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"John" <[e-mail] in message
news:er***********@textnews.wanadoo.nl...

>"salad" <oi*@vinegar.comschreef in bericht
news:4h*****************@newsread2.news.pas.earth link.net...

>>John wrote:

Is it possible to center a memo field value vertically? I use a memo
field for printing address labels and I would like the addresses to
show up centered vertically.
Thanks,
john

At first I thought you meant to have it centered. not left justified.
Maybe you do. If so, click the field and set the justification as
centered (in the format tab of property sheet)

But that sounded ridiculous so I thought maybe you are concatenating the
address to the city to the state etc. If so, you should put in a nlcr
in it. Ex:
Me.MemoFld = Address1 & vbNewLine & Address2 & vbNewLine & City...

Thanks. My address memo field value can take 4 to 7 lines, depending on
whether a department and subdepartment are included. If it's 4 lines then
the lower part of the label is white. I think I will fiddle with adding
an extra line at the start in that case so that the value seems centered
vertically.
john