INSERT question

Hey I'm really new to all this.

I'm trying to do an INSERT statement

It works but the text boxes can contain any value
so if someone types in ' or " it messes things up.

I'm sure this is a simple solution but I haven't been able to find anything anywhere

Please help!

Thanks

-X-

Assign your textboxes input masks. This will make it so that if a field and only hold numeric values, the user can only enter numeric values. If they are to be adding Dates, they can only enter dates.

S-

That would be good but I want users to be able to enter ' & " in their text messages

those symbols are reserved in SQL code and will cause you nothing but problems. You can't use them and use insert statements. There are ways to bypass that (ADO recordsets), but I still wouldn't recommend allowing those symbols if at all possible, espically in field that you will be searching against.

S-

Actually I finnaly found the answer

to insert a ' in an INSERT statment it needs to be put in as ''
i.e. INSERT INTO Table (text) VALUES ('Hello I''m Here')

" I didn't actually have a problem with. It does fine inside single quotes.

-X-