Line Break in text field in a form

Y

y770

..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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

line feed not showing in report 4
Run-time error 430: Class does not support Automation..... 4
mailing labels - square box at end of first line in report 8
comparing the date entered to a form and the date field in a table 2
Code runs slow - unbound form 1
Extract Access records to new workbook using VBA in Excel 6
Line break 5
Carriage Return Symbol Text Field Word Form VBA Problem inside Tab 2

Top