current date

[Jean]

Using a text box I entered "=date()" as the control
source, but when I view the form it is showing "Name?"
instead. How come this worked on my home pc (access 2002)
but not here at work? (access 2003)

Also, while I'm beggin, could I do the same for time?

thanks!

Jean A

 

[Allen Browne]

First, open this form in design view.
Right-click the text box and choose Properties.
On the Other tab of the Properties box, make sure the Name of the text box
is not the same as the name of any of the fields in the form's RecordSource.

If that does not solve the problem, you probably have a problem with
References. See:
http://allenbrowne.com/ser-38.html

To show the time in a text box, give it these properties:
Control Source: =Now()
Format: Short Time

 

[Jean]

....and BINGO was his NAMEO! thanks!

 

[Allen Browne]

Footnote: That Time text box won't update itself every second.
If you really want that, use the Timer event of the form to requery the
textbox.