line feed not showing in report

[Keith G Hicks]

I have some code that is concatenating names together using vbCrLf. I also
tried Chr(13)&Chr(10) which are supposed to be the same anyway. I assign the
names to a string variable and then in the OnFormat of the report detail I
assign the values to the caption of a lable. Trouble is the line feeds don't
end up in there.

Public sEmpNames as String
sEmpNames = ""

loop through the names table...
While ....
if sEmpNames = "" Then
sEmpNames = <next name in table>
else
sEmpNames = sEmpNames & vbCrLf & <next name in table>
endif
...movenext
Wend

In the report I'm simply doing this:

Me.lblEmpNames.Caption = sEmpNames

Like I said, the names appear but all jammed together. I've tried converting
sEmpNames to a function and using it in the source for a text box as well.
Neither strategy works.

The same sEmpNames variable is being used in a bookmark in Word automation
and it comes out fine. What's happening to my line feeds in the Access
report?

Keith

 

[Keith G Hicks]

I know the line feeds are there. When I put the variable in the Immediate
window, it runs the names out on separate lines.

 

[Keith G Hicks]

Never mind. My code for the Word automation was just using vbCr. That wasn't
enough. I do a Replace in the Access report so that vbCr's become vbCrLf and
it's all good.

 

[Armen Stein]

Never mind. My code for the Word automation was just using vbCr. That wasn't
enough. I do a Replace in the Access report so that vbCr's become vbCrLf and
it's all good.

Thanks for letting us know. That would have been a tough one for us
to spot without seeing all the actual automation code.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Keith G Hicks]

Yeah, it was pretty much making me nuts until I noticed that my automation
code used vbCr only. Then I rememberd that when I first set that code up,
vbCrLf didn't work as I expected so I just used vbCr. The thing that puzzled
me was that with just vbCr the breaks were there in the Access vba immediate
pane but not in the report controls preview.