Possible to

[HLCruz via AccessMonster.com]

I have a field in a table that will allow my users to create a "Mailing
Label". When we have two or more individuals at an address that need to
appear on a label as follows,
Jane Doe
Bob Smith
Address
City, State Zip
they'll use a comma to separate the names in the field - i.e., Jane Doe, Bob
Smith.

This will work when we export to a comma delimited text file and send to our
mailing house, but I'm wondering if there's a way to also print labels and
force that carriage return if the comma is present.

If anyone knows of a way to do this via query/VBA or if this is "impossible"
within Access I would greatly appreciate advice!

 

[Duane Hookom]

You should be able to change the control source to something like:
=Replace([UnnamedField], ",", "," & Chr(13) & Chr(10))
Make sure the name of the text box is not the same as a field name.

 

[HLCruz via AccessMonster.com]

Thanks Duane, just to clarify ... do you mean that I can change the control
source right on my labels? Thank you again! I was hoping it would be
something simple!

You should be able to change the control source to something like:
=Replace([UnnamedField], ",", "," & Chr(13) & Chr(10))
Make sure the name of the text box is not the same as a field name.

I have a field in a table that will allow my users to create a "Mailing
Label". When we have two or more individuals at an address that need to

[quoted text clipped - 12 lines]

If anyone knows of a way to do this via query/VBA or if this is "impossible"
within Access I would greatly appreciate advice!

 

[Duane Hookom]

You don't need our permission to attempt this.

--
Duane Hookom
Microsoft Access MVP

Thanks Duane, just to clarify ... do you mean that I can change the control
source right on my labels? Thank you again! I was hoping it would be
something simple!

You should be able to change the control source to something like:
=Replace([UnnamedField], ",", "," & Chr(13) & Chr(10))
Make sure the name of the text box is not the same as a field name.

I have a field in a table that will allow my users to create a "Mailing
Label". When we have two or more individuals at an address that need to

[quoted text clipped - 12 lines]

If anyone knows of a way to do this via query/VBA or if this is "impossible"
within Access I would greatly appreciate advice!