I'm trying to save the contents of a scrolling text box that i have create in my asp form and save the data into an access database. It will only save the first line of text and when I try to retrieve the data it doesn't show up. Can anyone help me with this?

do you mean you're using <input type=text> and doing something wierd with it, or are you using <textarea></textarea> and it's still only saving the first bit?

I am a loud man with a very large hat. This means I am in charge

I'm using <textarea></textarea>

Is the db field large enough for what you are trying to insert.

Can you post your code?

Cheers,

Chris

I haven't worked with Access in a while - but possibly if you're using a Text field type (it might even happen on Memo) that new line characters aren't loved by Access -
Maybe try something like
when updating, that way you can see if it is the newline characters causing you grief

I am a loud man with a very large hat. This means I am in charge

1. Your data type needs to be set to text or large enough to store all data. 2. You must read this field last from the recordset, otherwise this field and any fields read thereafter will not display.

Never heard of this before, and I must say that I'd have to disagree on principle. whether reading or writing to a recordset, it doesn't matter what the order of fields is.


I am a loud man with a very large hat. This means I am in charge