vbCrLf doesnt work in 2007 runtime, but works ok in the main app

[Dean]

Note: Re-posted this here from the "forms" section as this section seems more
appropriate.

Hi,

I have a database with a multi line memo field and I am creating carriage
returns using this code:

Me.Text48 = Me.Text48 & vbCrLf & sLst

It works great in Office Access 2007. However when I come to distribute it
among "client" computers running the Access 2007 runtime when executing that
line of code a [?] symbol appears in the text box.

This is what it looks like:

http://deanparkr.googlepages.com/questionmarksymbol.JPG

I cant understand why it would work fine in the main Office and not in the
runtime version?

Any ideas would be most grateful!

 

[Klatuu]

I'm wondering if vbCrLf has gone obsolete on us?
You can try vbNewLine
If that doesn't work, try
Chr(13) & chr(10)

Sorry I don't have 07 here so I can't test it.

 

[Arvin Meyer [MVP]]

Another possibility that may not be mentioned is References. It is quite
possible that their references may no match. This particularly true if the
versions of something like Outlook don't match. Since you are using Access
2007, and they may not be, this could be a problem.

I have some code at my website to list references:

http://www.datastrat.com/Code/GetReferences.txt

It probably won't work in the Runtime because I don't think that you can use
Debug.Print. Instead, replace that with a Message box and get the reference.
Should work OK.