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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
IrogSintaCommented:
Where is it getting that date/time if this is an unbound form?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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
IrogSintaCommented:
That explains it.  The function Now() includes the time.  You need to use the function Date() instead in the default value.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SteveL13Author Commented:
Thank you so much!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.