carriage return?

J

js

hi, how to put a
carriage return into a update query:

update tb1 set fd1 = "" + chr(13) + ""??



thanks.
 
D

Douglas J. Steele

You need both Chr(13) & Chr(10) in that order, and you really don't need the
null strings.

update tb1 set fd1 = chr(13) & chr(10)

Of course, I don't see what use fd1 is going to be!
 

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

Split data in field on character return 0
add carriage return to end of text 2
Trying to find a new line in combining fields 1
adding a Carriage Return or Line Feed character to an update query 2
Problems with carriage return in address field 5
Replace Carriage Return ASCII Character in Memo Field 3
Carriage Return 4
Update querry to memo field - How do I add a carriage return? 4

Top