Help with Insert into Access

benskywalker · September 26th, 2003, 10:39 AM

I have a small problem and I'm not sure that it is ASP related. But I uploaded a database. Now I set the field to memo so that I might have more entry space. Well I have 2 problems. 1 is that my input box is very small and might carry about 4 words. No matter what I try it does not get any bigger. 2 is that I still run into a field limit but I think it has to do with the lines available in my input box. any suggestions?

Steven · September 26th, 2003, 05:47 PM

Instead of using

Code:

<input type="text" name="textfield">

or something like that - why not use

Code:

<textarea name="textarea"></textarea>

Steven

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

benskywalker · September 26th, 2003, 07:52 PM

Ahh thanks for the input it really helped. Now my problem is.....why do I have a limitation on the information that I enter. This is the error that I continue to get. This only happens when I do large entries.

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression ''This is a test. I'm only doing this too see exactly how many characters I can put in here. I will soon edit this to actually take it out. I just REALLY wanted to test this thing. I'm really really hoping that I can just add up all of this stuff and make '.

/HOM/rec_add.asp, line 13

My database is set to memo so that I can take more information! Or I was hoping.

benskywalker · September 26th, 2003, 08:01 PM

From looking at it I'm really starting to think that it does not like wrapping. I'm guessing it is really the database. Is there a way to fix that?

benskywalker · September 26th, 2003, 08:10 PM

Nevermind. I found it and it is working just fine now. There is a wrap tag that you can input into a textarea tag. It is working just fine now thank you Everyone.