By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,484 Members | 1,851 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,484 IT Pros & Developers. It's quick & easy.

Center memo field vertically

P: n/a
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
Feb 24 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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...

Feb 24 '07 #2

P: n/a
"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
Feb 24 '07 #3

P: n/a
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" <jo@hn.comwrote 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

Feb 25 '07 #4

P: n/a
Thanks. Works great!
john

"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com>
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" <jo@hn.comwrote 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


Feb 25 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.