Carriage Ret + Line Feed on Access2K table with VFP6.0

[spayne]

I am dynamically creating and inserting data into Access 2K tables with VFP 6.0 using DAO and ODBC. I am having trouble with one field that requires data to go in as such:

Name
Address
City, ST Zip

Unfortunately, the CHR(13) function is not useful in this instance. I would appreciate any suggestions or ideas.

Thanks,
Steve

 

[ramani]

The data can be controlled using a EditBox instead of a text box. This could solve your problem.. thogh I have not tested this. Just a suggestion if it helps!

 

[spayne]

For those interested, it turns out CHR(13) + CHR(10) works like a charm.

Steve