Line spacing on printout

[JohnTheTemp]

Hi All,

I'm printing labels and I don't like the line spacing between the address
lines. The Company Name is always one line (as with the City, State, Zip).
The Address field can have more than one line.

Currently, the fields are stacked directly upon each other in design view.
The Address field is set to "can grow". When that Address field has more than
one line, the different spacing withint it is noticably different than the
spacing between it and the Company Name and the CityStateZip row.

I thought I'd try concatenating it using "[CompanyName] & chr(10) &
[CompanyAddress]" but that doesn't work. I get 'symbols' instead of a line
feed. :-(

Is there a nifty solution to getting a nice-looking printout.

Thanks in advance.

 

[Allen Browne]

Needs both a CR and LF, i.e.:
=[CompanyName] & Chr(13) & Chr(10) & [CompanyAddress]

There's another trick, using a subtle difference beween the 2 concatenation
operator, + and &. The difference is:
"A" & Null = "A"
"A" + Null = Null

So, you can suppress the spurious CrLfs with:
=[CompanyName] + Chr(13) + Chr(10) & [CompanyAddress] + Chr(13) +
Chr(10) & ...

 

[JohnTheTemp]

Spot on, Allen. Thanks very much.
--
JohnTheTemp

Needs both a CR and LF, i.e.:
=[CompanyName] & Chr(13) & Chr(10) & [CompanyAddress]

There's another trick, using a subtle difference beween the 2 concatenation
operator, + and &. The difference is:
"A" & Null = "A"
"A" + Null = Null

So, you can suppress the spurious CrLfs with:
=[CompanyName] + Chr(13) + Chr(10) & [CompanyAddress] + Chr(13) +
Chr(10) & ...

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi All,

I'm printing labels and I don't like the line spacing between the address
lines. The Company Name is always one line (as with the City, State, Zip).
The Address field can have more than one line.

Currently, the fields are stacked directly upon each other in design view.
The Address field is set to "can grow". When that Address field has more
than
one line, the different spacing withint it is noticably different than the
spacing between it and the Company Name and the CityStateZip row.

I thought I'd try concatenating it using "[CompanyName] & chr(10) &
[CompanyAddress]" but that doesn't work. I get 'symbols' instead of a line
feed. :-(

Is there a nifty solution to getting a nice-looking printout.

Thanks in advance.

 

[guat]

Hi, I'm trying to understand this e-mail below. Can you give another example
of using the + vs the &?

Needs both a CR and LF, i.e.:
=[CompanyName] & Chr(13) & Chr(10) & [CompanyAddress]

There's another trick, using a subtle difference beween the 2 concatenation
operator, + and &. The difference is:
"A" & Null = "A"
"A" + Null = Null

So, you can suppress the spurious CrLfs with:
=[CompanyName] + Chr(13) + Chr(10) & [CompanyAddress] + Chr(13) +
Chr(10) & ...

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi All,

I'm printing labels and I don't like the line spacing between the address
lines. The Company Name is always one line (as with the City, State, Zip).
The Address field can have more than one line.

Currently, the fields are stacked directly upon each other in design view.
The Address field is set to "can grow". When that Address field has more
than
one line, the different spacing withint it is noticably different than the
spacing between it and the Company Name and the CityStateZip row.

I thought I'd try concatenating it using "[CompanyName] & chr(10) &
[CompanyAddress]" but that doesn't work. I get 'symbols' instead of a line
feed. :-(

Is there a nifty solution to getting a nice-looking printout.

Thanks in advance.