Carriage return in a textbox

[yippie_ky_yay]

Hello forum,

am I missing something? I want to insert a carriage return in my text box:

=[FieldName] & Chr(13) & Chr(97) & "some text"

I tried all combinations with 13 and 97 - also with and without the "$" after the Chr part.

What I get is a [] (box) or the letter "a" - I read a similar post and this seemed to be the solution!

Any help would be greatly appreciated!

-Sean
(Access 2k)

 

[Rich]

Chr(13) & Chr(10)

 

[yippie_ky_yay]

Thanks Rich!

 

[Raneil]

Thanks.

Yes, thank you indeed!