Displaying SQL date in Access form

  • Thread starter Thread starter William Ortenberg
  • Start date Start date
W

William Ortenberg

With an Access 97 front-end, and a SQL Server 2000 back-end, I have a
field on a form representing a SQL datetime column that I only want to
see in a Short Date format (xx/xx/xxxx). I set the format accordingly
(Short Date), and the field displays as expected. However, when I
attempt to edit the field, the 'time' portion of the field appears. Is
there any way to prevent this?

Thanks in advance.
 
Have you tried setting the InputMask for date only on the Textbox Control?

Check Access / Access VB for InputMask.

--
HTH
Van T. Dinh
MVP (Access)



With an Access 97 front-end, and a SQL Server 2000 back-end, I have a field on a form representing a SQL datetime column that I only want to see in a Short Date format (xx/xx/xxxx). I set the format accordingly (Short Date), and the field displays as expected. However, when I attempt to edit the field, the 'time' portion of the field appears. Is there any way to prevent this?

Thanks in advance.
 
Back
Top