hi:

I,m writing a software for one of the departments of Louisiana State
university.I have a question regarding this.

I'm using MS Access 2.0 as back end and Visual Basic 4.0 as front end.
I have a mask edit box for the date field and the data type for this has
been declared as date/Time in the table in access.

The system is giving an error message when i leave the date field blank.

How do i overcome this.I want to code in such a way that even if they
don't enter anything in this mask edit box the record should be
accepted.

I would appreciate if you can give me the code.

If you need some more clarifications you can E_mail me.I will be glad to
answer you.

Thanx

ganesh

On Sun, 01 Sep 1996 11:37:17 -0500, Ganes Vaidhyanathan

If the field  is part of the primary key. Do the above, then set the
atribute for the key to accept null values.

Peter Mikalajunas

http://www.xnet.com/~kd9fb

Depends on how your database has been setup.  What is the error message and
what
has the field in question been set up as.  Are NULL allowed on this field,
You must reconsider the design of this field if so. Why is a field that has
been setup for
NO NULL's being set to a NULL.  If you really don't want to have a NOT NULL
constraint on
this field, remove it. Otherwise set the value up properly in the Text box.

While I would not recommend this method, you can try this to get around the
problem
through the back door.
One way around this would be to write code in the LOST_FOCUS event handler
for the
masked test box.  If the Len(text) = 0 then set the text = "" .  This will
force an empty
value to be written to the field.

Best regards
Umesh Murthy