By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,816 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

SQL Server date on Access form

P: n/a


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
Share this Question
Share on Google+
1 Reply


P: n/a
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.