vbCrLf or vbLF or vbCRLF ???

mat41 · May 24th, 2005, 08:59 PM

I am workng with some MGP (Microsoft Great Plains) tables or should I say data in thier tables. I do not have the ability to change the way MGP inserts or deals with data/data types in any way.

I have hit a road block trying to display some data from a text data type field. They have inserted squares in the string, these represent a vbCrLf. Usually I run a function that replaces these with a <br> like so:

  Function DisplayMemo(theText)
    DisplayMemo = ""
    on error resume next
    DisplayMemo = CStr(theText)
    if (len(DisplayMemo) > 0) Then
      DisplayMemo = Replace(DisplayMemo, vbCrLf, "<br>", 1, -1, 1)
    end if
  End Function

Has anybody encountered this square (literaly) before and know how to deal with it?

TYIA

Wind is your friend
Matt

happygv · May 24th, 2005, 11:16 PM

Hi Matt,

Did you try with replacing CHR(13) or CHR(10) instead of VbCrLf? See if this helps.

Code:

DisplayMemo = Replace(DisplayMemo, CHR(13), "<br>", 1, -1, 1)

As the VbCrLf is intepretted differently in different apps.

Let me know if that worked.

Cheers!

_________________________
- Vijay G
Strive for Perfection

mat41 · May 24th, 2005, 11:24 PM

Great stuff happygv - problem solved using CHR(13) - thanking you very much.

Wind is your friend
Matt