ACCESS 97 carriage returns in memo fields

  • Thread starter Thread starter Mike Giddings
  • Start date Start date
M

Mike Giddings

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
 
Back
Top