labels

[Bill H.]

I've got a query to build an address for use in printing labels.

I want to insert a crlf to separate two address lines, but only if the
second address line contains data. I don't want to put three address lines
into the label form.

Only problem, I can't get the "& vrcrlf &" to work.

Do I need to use a different command in queries?

Thx.

 

[Ken Snell \(MVP\)]

This should work:

SELECT Address1 & (Chr(13) + Chr(10) + Address2)
AS CombinedAddress
FROM TableName;

 

[Bill H.]

Dang!

I had forgotten about the chr(10). I did the Chr(13) and just got a little
rectangle.

Thx.

This should work:

SELECT Address1 & (Chr(13) + Chr(10) + Address2)
AS CombinedAddress
FROM TableName;
--

Ken Snell
<MS ACCESS MVP>



"Bill H." wrote in message news:[email protected]...