Getting The Current Date

[JiTS]

Display today's date correctly

Hi,

I am able to show today's date in a form with the function =Now().

If I am viewing the form I see the date correctly.
For example: Friday 12 December 2003

But if I click on the date then it's changing to:
12-12-03 12:10:55

What to do to prevent this?

 

[Oldsoftboss]

If the field on your form is unbound you only need to put
=Date() in the control source.
The usage of =now() is exactly that....Now - to the second.
By click ing in the field once you change the control source to =Date() will still alter the date from long date format to short date format though.
HTH
Dave

 

[JiTS]

I guess that's not the answer for my question.

I use a textbox to show the current date (function =Now()).

If somebody uses my database and he cliks on the showing date (Friday 12 December 2003), I don't want that it will appears in 12-12-03. It have stay in Friday 12 December 2003... so that means that you're not able to click on it or whatever.

I changed =Now() in =Date() but no effects.

Please help...

 

[Mile-O]

Set the textbox's Enabled property to No, and its Locked Property to Yes.

 

[JiTS]

Thnx!

I've got the dutch version of Access... so I had to search a little to find it, but that's the answer for my question.

Thanks for your help!

 

[Oldsoftboss]

Mile-O-Phile to the rescue again
Dave