Memo field in my replace function

[Lukas]

Hi all

I have a problem with my function.
This function cut my variable StringIn on 255 long char.
But variable value StringIn is as memo type. For examle 800 long char...


Function ReplaceText(StringIn As String) As String
Dim NewString As String
NewString = Replace(StringIn, "+++", "<li>")
ReplaceText = NewString
End Function

Hepl me please.......

Thanks..

 

[John Spencer]

Are you using the function in a query?
If so, are you using DISTINCT or GROUP BY or UNION in your query. Those
will truncate a memo field to 255 characters.

If you don't use the function but just the field, does that truncate the
field's value to 255 characters?

I used Replace on a memo field and did not experience the problem in a
standard select query. If I used Distinct or Grouped by the results, my memo
field was truncated to 255 characters.