running a current date macro

[Baggers]

Hello everyone

I am trying to set up a button in my form (access) that will autofill the datefield with todays date and appear in the format dd/mm/yyyy. I've attempted a macro to do this but it only works after i ve right clicked in the date box and gone to properties then closed it. I've absolutely no idea why, in the 'set value' section i've used the code;

Format(Date(),"dd/mm/yyyy")

Does anyone have any tips as to where I'm going worong, I'd be very grateful

cheers

baggers

[Baggers]

What's strange is the date appears to be in the box as you can click in the end of the box and delete one character and then the rest of the date appears?

[Hack]

Try

TextBox1.Text = Format(Now,"dd/mm/yyyy")