Low values for DATE field..

[Bosch]

Hi all..

I have a DATE/TIME field in a table. I want this field to be optional.
But when I try to insert a record without a date value for this field, the SQL fails. How do I fix that ?

Also I want to display this field only if there is a valid date...How can I do that?

Thanks in advance..

 

[WayneRyan]

Bosch,

First of all, if the Table Definition states DateTime, then only a valid date
will be stored.

If the Date/Time field does not have to ALWAYS be present, go to the table's
design. Then for the Required (or Allow Null) property, enter "NO".

Then, on your form, if you don't want to display it, you can use the OnCurrent
event to make the field either invisible/visible. Remember to do both. Access
has a good memory.

Wayne

 

[Bosch]

Thank you Wayne..I think I didnt explain my problem properly.

I had an INSERT SQL with this DATE field. When the date field is not entered then it has null and SQL fails. Now I have two SQL's one with DATE field, one without. So, I am OK now.

Thanks anyways.