todays date as default value

J

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
 
K

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
 
K

Ken Snell [MVP]

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