How make short date field on a form display only the month/day/year

I have a date field on a form and the format is Short Date.  But I want it to only display for example 10/19/2014 when the focus is on the field.  Right now it shows for example 10/19/2014 9:10:38 AM

How can I change this?
SteveL13Asked:
Who is Participating?
 
IrogSintaConnect With a Mentor Commented:
That explains it.  The function Now() includes the time.  You need to use the function Date() instead in the default value.
0
 
IrogSintaCommented:
Instead of Short Date in the Format property of that particular control, use mm/dd/yyyy.

Ron
0
 
SteveL13Author Commented:
Didn't work.  It still shows "10/19/2014 9:10:38 AM" when the focus is on the field.  This is an unbound form if that helps.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
IrogSintaCommented:
Where is it getting that date/time if this is an unbound form?
0
 
SteveL13Author Commented:
It is a form used to locate a record or records based on the date range the user enters.  See screen shot.

Then there is a query which is the record source for a report that uses:

Between [Forms]![frmname]![txtStartDate] and [Forms]![frmname][!txtStartDate] for the criteria.

All I need is for the date field(s) on the form to display just "10/19/2014"  instead of "10/19/2014 9:10:38 AM" when the focus is on the field
0
 
IrogSintaCommented:
You forgot the screenshot.
0
 
SteveL13Author Commented:
Sorry.  Here are two... one before the date field gets the focus and one after the date field gets the focus.  You can see that the time starts to display (and would fully display if the field was longer.

before focus
after focus
0
 
IrogSintaCommented:
So you actually selected a date from the date picker calendar rather than entering something in the field?
0
 
SteveL13Author Commented:
The default of the date fields is =Now()

When I click on the date field as if I wanted to manually enter a date, the time shows up.
0
 
SteveL13Author Commented:
Or even if I just click on the date field to use the calendar date picker the time shows up.
0
 
SteveL13Author Commented:
Thank you so much!
0
All Courses

From novice to tech pro — start learning today.