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

Carriage Return Issue

P: n/a
I have a VBA function that returns a string including "vbcr" (VB Carriage
Return) to seperate a list into multiple rows, eg Item1 & vbcr & Item2 &
vbcr & Item3
This works as planned in the immediate window, producing a list where a
Carriage Return follows each item. But when I output the result into either
an Access query or form, instead of carriage returns I get little square
symbols between each of the items. Is anyone able to tell me how to achieve
my objective of getting carriage return characters in vba that Access can
interpret?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Andrew Chanter" <he****@radsolutions.com.au> wrote in message
news:nx******************@news-server.bigpond.net.au...
I have a VBA function that returns a string including "vbcr" (VB Carriage
Return) to seperate a list into multiple rows, eg Item1 & vbcr & Item2 &
vbcr & Item3
This works as planned in the immediate window, producing a list where a
Carriage Return follows each item. But when I output the result into either
an Access query or form, instead of carriage returns I get little square
symbols between each of the items. Is anyone able to tell me how to achieve
my objective of getting carriage return characters in vba that Access can
interpret?


Standard Access controls require both a carriage return and a line feed. Use
vbCrLf instead.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
many thanks Rick

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:30*************@uni-berlin.de...
"Andrew Chanter" <he****@radsolutions.com.au> wrote in message
news:nx******************@news-server.bigpond.net.au...
I have a VBA function that returns a string including "vbcr" (VB Carriage
Return) to seperate a list into multiple rows, eg Item1 & vbcr & Item2 & vbcr & Item3
This works as planned in the immediate window, producing a list where a
Carriage Return follows each item. But when I output the result into either an Access query or form, instead of carriage returns I get little square
symbols between each of the items. Is anyone able to tell me how to achieve my objective of getting carriage return characters in vba that Access can interpret?
Standard Access controls require both a carriage return and a line feed.

Use vbCrLf instead.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.