From: y770 on
..EmpName = strNameI am populating an unbound text field in a form thru VBA.
Code is :
While Not rs1.EOF
strName = strName & rs1!Name & Chr(13) & Chr(10)
rs1.MoveNext
Wend
..txtBox = strName

For some reason all Names come as one long line which is wrapped by the
width of the text box. I tried also to use "vbcrlf" with the same effect. Is
there some properties to change?