todays date as default value

[Jens Hofmeier]

Hello,

i've got an unbound textfield which should display as default valu the
actual date in the following format "dd.mm.yy". It is important that the
format of the year is only 2 digits long. I've tried
=Format(Date();"dd.mm.yy") as default value, but it did not work.
Can somebody help?


Thanks,

Jens

 

[Ken Snell [MVP]]

Define "did not work".

I might be inclined to use this as the default value:
=Date()

and this as the Format property:
dd.mm.yy

 

[James Arnold]

Try:

=Format(Date(),"dd.mm.yy")

(comma, not ";")

 

[Ken Snell [MVP]]

Many non-US versions of ACCESS use ; instead of , as the argument delimiter.