#Name? error in date text box

[Adrian Laboy via AccessMonster.com]

I have a form with a text box, the textbox default value is =Date() but when I open the form the textbox appear with #Name?
Has anyone seen this before?....how can I eliminate this and have the date appear on the text box...any help will be appreciated
Thanks

 

[tina]

open the form in design view. click the textbox once to select it. in the
Properties box, go to the ControlSource property (second line on the All
tab) and click on the line, then click the down arrow to show the droplist.
does the field in the ControlSource match a field in the droplist? if not,
select the correct fieldname from the droplist.

hth

I have a form with a text box, the textbox default value is =Date() but

when I open the form the textbox appear with #Name?

Has anyone seen this before?....how can I eliminate this and have the date

appear on the text box...any help will be appreciated