Displaying SQL date in Access form

[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.

 

[Van T. Dinh]

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.