Date()

[northernbreaks]

Hi
I have setup a textbox and set the expression in the Control Source to =Date()

When I run the form the textbox displays '#Name?'

Anyone any ideas


Dave

 

[KenHigg]

Maybe it should be in the default value property...?

 

[northernbreaks]

still no joy.

I have tried writing this into the form 1sec timer event to update the textboxes.
txtTime_01.Value = Time ' Update time display.
txtDate_01.Value = Date
The Time works but not the Date, it displays nothing.


Dave

 

[RuralGuy]

Any chance you've named a control or field Date? That would be a no-no.

 

[northernbreaks]

Hi
I think you may be right, I have tried it on other forms and it works, there must be something on this form that is causing the problem.

Thanks


Dave

 

[Bat17]

I would also check in any module Toos>References... for broken references.

HTH

Peter

 

[KenHigg]

Does it compile?

 

[northernbreaks]

Hi Guys
It does compile and I found the problem. The table that the form was linked to had a field with the same name (Tut, Tut, boob on my part), so I changed the field name, and it works fine.

Cheers

Dave

 

[KenHigg]

You had a field named 'Date' ?