Hi!
PADR(chrtran(mMemoField,chr(13)+chr(10),' '),200)
Grid crash or behave inproperly when value returned by expression in the column is longer than 200 character or have different length/type for different rows.
BTW, you can use editbox in the grid column, it will display Memo field content completely when you provide anough space for editbox by using RowHeight property of grid.
HTH.
>Thanks for your help. I used the alltrim option and it works unless there is more than a few lines of text in the memo field, in which case I get an error message saying 'string is too large'. Presumably this is because the width of the column limits the size of the string?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.