View Full Version : Carriage return in a textbox


yippie_ky_yay
01-31-2003, 07:08 AM
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
01-31-2003, 10:08 AM
Chr(13) & Chr(10)

yippie_ky_yay
01-31-2003, 07:32 PM
Thanks Rich!

Raneil
09-19-2005, 11:33 AM
Yes, thank you indeed!