Newline symbol for a record

[xtraterrestrial]

Hi

I have text field in a record where I want to output information to a textbox. Is there a way to input a new line character to the text field so I can show my information in the textbox nicely?

I tried using chr(10) but that doesn't seem to work. I think this is because the field in my table changes the chr(10) into something else.

 

[WildHare]

Split your data apart and toss in the VBA constant vbCRLF, for a carriage return/line feed:

MyNewText = Left(Textguy,50) & vbcrlf & Mid(Textguy,51)

or whatever...MyNewText will look like this:

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

if you have a full 100 characters in TextGuy, when you toss it in a text box that's 'deep' enough.





If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm