Delete Contents of Date Field

  • Thread starter Thread starter Renraf
  • Start date Start date
R

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.
 
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".
 
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
 
Back
Top