Problem: textbox default value = Date()

[zSplash]

I want an unbound textbox on my form to default to current date. In the
default value property of the textbox, I put "=Date()". Instead of today's
date, it defaults to the text "date". What am I doing wrong?

(I see if I bind the textbox to "=Date()", the value, of course, is today's
date, but I only want the default to be today's date, which can be changed
as needed.)

TIA

 

[missinglinq via AccessMonster.com]

Are you actually entering

"=Date()"

or are you entering

=Date()

without the double quotes?

If the latter, it should give you the date!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[zSplash]

Excuse me. I am not entering the quotes. Sorry. (I go to the Expression
Builder | Common Expressions | Current Date and paste that, which results in
=Date() as the default value.)

 

[Powderfinger]

remove the quotes

=Date()