I am trying to add two strings into a memo field separated
by a carriage return so that when the memo field is
displayed in a report the second string starts on a new
line. I am adding the two strings as part of a VB module
(ACCESS 97).

I have tried
memoname = string1 & chr(13) & string2
but this displays a square (unprintable character) between
the two strings.

I would be most grateful if you could tell me what to
replace the chr(13) with.

Thanks
Mike Giddings

Instead of Chr(13), use vbcrlf.

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com


"Mike Giddings" <(E-Mail Removed)> wrote in message
news:08d801c37152$f4dee090$(E-Mail Removed)...
> I am trying to add two strings into a memo field separated
> by a carriage return so that when the memo field is
> displayed in a report the second string starts on a new
> line. I am adding the two strings as part of a VB module
> (ACCESS 97).
>
> I have tried
> memoname = string1 & chr(13) & string2
> but this displays a square (unprintable character) between
> the two strings.
>
> I would be most grateful if you could tell me what to
> replace the chr(13) with.
>
> Thanks
> Mike Giddings

Many Thanks - worked a treat. Thanks for your help.

Mike
>-----Original Message-----
>Instead of Chr(13), use vbcrlf.
>
>--
>Paul Overway
>Logico Solutions, LLC
>www.logico-solutions.com
>
>
>"Mike Giddings" <(E-Mail Removed)> wrote in
message
>news:08d801c37152$f4dee090$(E-Mail Removed)...
>> I am trying to add two strings into a memo field
separated
>> by a carriage return so that when the memo field is
>> displayed in a report the second string starts on a new
>> line. I am adding the two strings as part of a VB
module
>> (ACCESS 97).
>>
>> I have tried
>> memoname = string1 & chr(13) & string2
>> but this displays a square (unprintable character)
between
>> the two strings.
>>
>> I would be most grateful if you could tell me what to
>> replace the chr(13) with.
>>
>> Thanks
>> Mike Giddings
>
>
>.
>