By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,061 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Combine 2 memo fields and insert a blank line

P: n/a
I am trying to write an Update query to update a field by combining 2
other fields. However, there is a slight twist. I wish to insert a
carriage return or a blank line in between the 2 fields. Can this be
done and if so how?

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
da************@hotmail.com wrote:
I am trying to write an Update query to update a field by combining 2
other fields. However, there is a slight twist. I wish to insert a
carriage return or a blank line in between the 2 fields. Can this be
done and if so how?

? "Joe" & chr(13) & chr(10) & "Blow"

? "Joe" & chr(13) & chr(10) & chr(13) & chr(10) & "Blow"
Nov 13 '05 #2

P: n/a
air code: (not syntactically correct, but the general idea)
field1 & vbcrlf & field2
or for a blank line: field1 & vbcrlf & vbcrlf & field2
vbcrlf stands for visual basic carriage return line feed

<da************@hotmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...
I am trying to write an Update query to update a field by combining 2
other fields. However, there is a slight twist. I wish to insert a
carriage return or a blank line in between the 2 fields. Can this be
done and if so how?

Nov 13 '05 #3

P: n/a
Thanks. Found a solution elsewhere. Used + chr(13) + chr(10) + chr(13)
+ chr(10)

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.