labels

  • Thread starter Thread starter Bill H.
  • Start date Start date
B

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.
 
This should work:

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

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

Thx.

Ken Snell (MVP) said:
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]...
Click to expand...
 
Back
Top