Don't want time to show up in date field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Although I used the following for format and input mask, time still shows up
when I click on the date field:

Format: :Short Date
Input Mask: 00/00/0000;

Please advise what I need to do to stop the time from showing...

Thanks.
 
It could be that the field format used to be general date and the value been
stored with houres and minutes, so every time the field get the focus, it
auto display the all value.
My suggestion to run a one time update query to update the date to short date

UPDATE MyTable SET MydateField = Format([MydateField],"dd/mm/yyyy")
or
UPDATE MyTable SET MydateField = Format([MydateField],"mm/dd/yyyy")
depent which date format you are using
 
Back
Top