Hi all, this is my question :-

I've created a table in ms sql server 7.0 using the enterprise manager. there i've a field named "address" which is a varchar type field. now in my vb6 apps i used a multiline textbox to write address. now when i'm trying to save the address from this textbox to the table only first line is getting stored and other parts are getting ignored.

what actually happening is, when i'm typing the address without pressing the enter key it's getting stored in the table. But when i'm creating new line by pressing the enter only the first line is saving. i just can't understood what is wrong in the logic. can anybody here to help me out plz...

it's really urgent

thanks in advance...