Carriage Return Issue

[Andrew Chanter]

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?

[Rick Brandt]

"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

[Andrew Chanter]

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