Have you tried CHR(13)+CHR(10)?
>I am dynamically creating and inserting data into an Access 2K database with VFP 6.0 using ADO and ODBC. I am having problem with one text field that requires data be inserted on three lines. For example:
>
> Name
> Address
> City, ST Zip
>
>all go into one text field as seen. The CHR(13) function does not work here. Any ideas?
>
>Thanks,
>Steve
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05