You have to transform CHR(13) and CHR(10) into \r\n for line breaks to work.

>I had a VFP.dbf system that got pulled up to SQL Server. I am now taked to make a WIN fat client with local data for customer lookups. I chose to do VFP for data.
>
>Having a problem with "Notes" that were say 5 paragraphs describing our parts and issues you need to know about them.
>
>I created a SQL Table column TEXT, and the data is fine in SQL, 1 paragraph per transaction. When I go back to a dump of the data in VFP, I get 3,4,5 memo transactions. and when I show that in a datagrid, it doesn't wrap. Is there some setting inside of a WIN grid to:
>1) Set only column in table to full width of container
>2) CanGrow = true
>3) or Word Wrap = true
>
>TIA
>
>__Stephen