now function in a form

M

Marsh

On a form in Access 2003, I created an unbound control and inserted the
formula =now()
The date and time is displayed. We do not want the time, just the date so I
selected the ShortDate format in the Properties.

Works fine, unless someone clicks the control, in which case the time
reappears. The form must closed and reopened to remove the time.
Can anyone explain this and suggest a work around.

Thanks
Marsh
 
D

Dirk Goldgar

Marsh said:
On a form in Access 2003, I created an unbound control and inserted the
formula =now()
The date and time is displayed. We do not want the time, just the date so
I
selected the ShortDate format in the Properties.

Works fine, unless someone clicks the control, in which case the time
reappears. The form must closed and reopened to remove the time.
Can anyone explain this and suggest a work around.
Click to expand...


Use =Date() instead.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying Data Forms in Excel 2016 for Mac 0
displaying dates in UK format 10
DCount Records to Display in Form 9
Date recalculates 1
Run-time error '2115' 4
image on form 3
dafault value for date not working with Date() but Now() is workin 5
Date parameters for report 3

Top