inserting null into DB

hi

I am encountering a problem as follows:
I have a text box called fax no on the form,
its stored into the dbase as numeric data field
now the problem is that i can't insert a null value
into the numeric field,
(that is in the absence of fax no)
What can i do in such a case???
I need to insert null into the DB, if fax no is not provided
instead of stopping the whole insert query.

.

Relevant Pages

  • Re: How to store numeric data in currency format other than $
    ... >I have a numeric data field for the UK currency ie £. ... >How to store this numeric data in Access database with the currency sign ...
    (microsoft.public.access.forms)
  • SUM (?) in Report
    ... Textbox1 to display VolPurge1; ... Textbox9 to display VolPurge9 (Numeric data field too). ... When there are numeric data in all fields, the SUM work ...
    (microsoft.public.access.reports)
  • Re: inserting null into DB
    ... I am encountering a problem as follows: ... its stored into the dbase as numeric data field ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)