Replace "," with a carriage return in a fucntion dec

[gooseriver]

In Access 2000 in a module I have the following:

Function Tes(pTd1 As String, _
Optional pTd2 As String = ",") _
As String

I want to replace the "," with a carriage return. I run a query that calls this fucntion... I know this is simple but just cannot figure it out...

 

[SkipVought]

Hi,

Function Tes(pTd1 As String, _
        Optional pTd2 As String = [b]vbcr[/b]) _
            As String

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[gooseriver]

When I use vbcr it places the square which indicates Carriage Retunr but when I run a report against it the report will show the carriage return without actually using the carriage return.

 

[SkipVought]

try vblf instead.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[gooseriver]

Man oh man.. same thing shows as 11square22square33 when connecting the Access Report to the query. However when I copied the result and tried to paste it to this reply, the numbers were entered an the next line (correct)... What is going on?

 

[gooseriver]

what about & Chr(13) & Chr(10)&

How can I add this ?

 

[JerryKlmns]

Chr(13) & Chr(10)= vbCrLf