Clearing a date Control on a form

[Liz_I3]

Hi
Iam trying to clear a date control on a form that is formatted as a short date with an imput mask as 00/00/00;0;_ I cannot get the value of the contol to clear I have tried:
[mydate].Value = " "
[mydate].Text = " "
[mydate].text = """""
[mydate].value = """""
[mydate].value is null

All my other fields clear with .text or .value = " "
Please what am I doing wrong

thanks
liz

 

[Dugantrain]

Have you tried simply [mydate]="" or [mydate]=Null? VBA works a little differently than VB in this respect.

 

[Liz_I3]

THANK YOU
yes [mydate]="" I could swear I tried that yesterday and it did not work

But I am very please it is working now. Do you know why in some cases I use " " and in this case "" why would it not be consistent?

Thanks Liz

 

[Dugantrain]

Not exactly sure what you mean. I always use "" to return an empty string. If you're getting an error with " ", this may be because the field in question is a date field and you're trying to place a single text character (even though it's just a space) into that field.