Insert Into 'Problem' - txt box empty - err - 'Data Type Mismatch

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with various text boxes etc. - Click 'Save' button - all Ok -
but if e.g. a text box is left empty - then when 'Save' is clicked - error on
SQL - INSERT INTO table****** - 'data type mismatch' occurs.
The field is set in the table as not required, it is a date field, how can I
enter nothing without error occurring ??? - any help - Thank you very much
!!!!! Ian
 
What does your Save button do? Are you actually creating a SQL statement and
running it?

If so, how are you creating the SQL statement?
 
Back
Top