how to force datepicker to show date only, not time

Hi All,
I'm sure this has been answered before, but hopefully quick.
how to force datepicker to show date only, not time. I have set the format to 'short date' (and it displays so) but when the textbox gets focus the full timestamp is displayed
thanks
LVL 7
COACHMAN99Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
can you closed this thread now.
0
 
Rey Obrero (Capricorn1)Commented:
is the control source field of the textbox set to "Short Date" too?

open table in design view and set the Format property of the field to Short Date
0
 
COACHMAN99Author Commented:
its not bound
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Rey Obrero (Capricorn1)Commented:
there could be some code that is interacting with your control.
setting the format to Short Date and Show Date Picker to For Dates should work

do a compact and repair.

add another textbox and set the property as mentioned above
-if that works, delete the textbox that shows date and time
0
 
COACHMAN99Author Commented:
thanks Rey.
there is no code that is interfering, and c&R will not help (although I have done this for other reasons).
Whenever I add an unbound textbox and set the format (short date) the box always displays the full timestamp when it gets the focus.
This behavior has been around for a long time.
I only want to see the date part on getfocus
0
 
Rey Obrero (Capricorn1)Commented:
then, there is something wrong with your Office application
I just tried on A2007,A2020, A2015 and A2016 and they all give me correct results.

try creating a new form the add a textbox and test.
0
 
COACHMAN99Author Commented:
nothing wrong with Office - this problem occurs on all machines (2010-2016). (and has done so with Access for many years) .
I add an unbound textbox
set the format to short date
when it gets focus there is a full timestamp displayed.
when a date is selected, and focus is lost, only the date is displayed as required.
0
 
Rey Obrero (Capricorn1)Commented:
<when it gets focus there is a full timestamp displayed.>

is there an entry in the Default Value property like =Now()
0
 
COACHMAN99Author Commented:
yes. you are quite right. I used Now() instead of Date()
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.