I created a form in asp & connected it to a MS Access database . I'm facing two problems .
1. When I enter data with some space in between two words in a textfield, then in the database the first word is coming till the first white space .
2. When a data inputted has a apostrophe in it , then an error message comes in the browser .
Please give me the solutions .
waiting for your quick reply.
swetha

I'm going to give it shot. I used FrontPage on my web input page. If you did, look into the the data validation options. Without looking, I'm not sure exactly where it is, but you have to ADD whitespaces and apostrophes as permitted characters or the browser will not record them.

HTH