Setting Date/Time to 0

JP

Hi:

I need to use VB in Access 2000 to empty Time and Date fields. Can anyone
tell me how to do this?

If I put Time.Text = 0 then I get an error... If I set it to "" I get an
error... how can I make it a nullfield?

Thanks

JP

Jul 23 '08 #1

Salad

JP wrote:

Hi:

I need to use VB in Access 2000 to empty Time and Date fields. Can anyone
tell me how to do this?

If I put Time.Text = 0 then I get an error... If I set it to "" I get an
error... how can I make it a nullfield?

Thanks

JP

Me.TimeFld = Null

Jul 23 '08 #2