current date as a default

[bmelv via AccessMonster.com]

hi,
i'm trying to use the current date (i.e what it is on the computer) for the
default value in a text box i've got on a form, but can't seem to work out
how to do it.
any help much appreciated,
cheers
b

 

[Rick Brandt]

hi,
i'm trying to use the current date (i.e what it is on the computer)
for the default value in a text box i've got on a form, but can't
seem to work out how to do it.
any help much appreciated,
cheers
b

=Now()

....will give you the current date and current time.


=Date()

....will give you the current date at midnight.

 

[bmelv via AccessMonster.com]

Right it does to!!

Thanks alot, too easy....

hi,
i'm trying to use the current date (i.e what it is on the computer)

[quoted text clipped - 3 lines]

cheers
b

=Now()

...will give you the current date and current time.

=Date()

...will give you the current date at midnight.