Carriage Return in text field

[crook_n_flail]

I'm trying to store a string in a text field that contains a carriage return. I build a string with a chr(13) statement but when i view this field in a report it doesn't do a carriage return. Any help is greatly appreciated.

Crook_n_flail

 

[Travis]

use Chr(13) & Chr(10) together. See if that helps. Chr(10) is the Line Feed

[This message has been edited by Travis (edited 10-09-2001).]

 

[chrismcbride]

You can also use the VB constant for a carriage return and line feed

vbCrLf

 

[crook_n_flail]

Thanks very much for your help. Both options work just fine. I had used chr(13) without chr(10) and that was what was holding me up. Thanks!