Delete Contents of Date Field

[Renraf]

Based on a condition, I want to make a date field blank/empty/null. How do I
do this? I tried

Me.Stop=Null
&
Me.Stop=""

But it gave me a very strange error (Run-time error '-2147352567
(80020009)': The object doesn't contain the Automation object 'DailyLogs.')
"DailyLogs" is the name of the parent form. But when I set it equal to any
other arbitrary value, it works.

 

[Dorian]

It depends on how the column is defined and where you are intending to perorm
this operation.
If nulls are allowed, you should be able to code:
Me!MyFormControl.value = Null
where MyFormControl is the control on the form that is bound to the date
column.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Damon Heron]

Just a guess, but Stop is a statement in Access. Is that the name of the
field with the date? Try changing it and see if that fixes the problem.

Damon