470,815 Members | 3,087 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,815 developers. It's quick & easy.

SQL Server date on Access form



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.

 
Nov 12 '05 #1
1 1640
William Ortenberg wrote:
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?


Set the Input Mask property of the Text Box to 90/90/0000;;_

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Bob | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.