ACCESS 97 carriage returns in memo fields

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace Carriage Return Symbol 6
Replace Carriage Return ASCII Character in Memo Field 3
Restoring line breaks in memo field 1
VBA line feeds in memo field 2
Access Access 2003 Carriage Return Insertion 0
Remove carriage returns in memo fields 1
Remove Carriage Return symbols from data 2
Removing Carriage Returns from Memo Fields 1

Top