Gustav Brock
Gustav at cactus.dk
Fri Feb 17 11:46:27 CST 2012
Hi John Sounds like are linking to a field of data type DateTime2 which Access doesn't understand, thus it is casted to a string. Change the field to data type DateTime. /gustav >>> jwcolby at colbyconsulting.com 17-02-2012 18:22:00 >>> I am binding a form to a sql server table. A date control is displaying the date in YYYY-MM-DD format even though I have a mm/dd/yyyy as a format string. Any ideas why I am seeing this? -- John W. Colby Colby Consulting