Stuart McLachlan
stuart at lexacorp.com.pg
Tue Jun 5 22:15:24 CDT 2012
I seem to recall having the same discussion about a year ago where we identified the problem with the new SQL Server Date and Time types and ODBC returning them as strings :-) -- Stuart On 5 Jun 2012 at 22:14, jwcolby wrote: > Ahh I figured it out. I had this working in the past. The key seems to be not using the time() > format but rather using the DateTime format in SQL Server. > > Sorry for the ring. > > John W. Colby > Colby Consulting > > Reality is what refuses to go away > when you do not believe in it > > On 6/5/2012 9:38 PM, jwcolby wrote: > > I am stumped on how to display a SQL Server time value in an Access form while leaving it editable. > > If I look directly in the table in SQL Server a time is displayed like this: 08:45:00.0000000. > > Likewise it is displayed in the Access form in that manner which of course is a major annoyance. > > > > Access input masks work correctly for stuffing the times in but "formats" such as Short time etc > > have no apparent effect at all. For reporting I can simply do a left(SomeTime,5) to get HH:MM format > > but of course I can't do that in the form's text field. > > > > So how the heck do I do this format in the form to display just the hour and minute? > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- Stuart McLachlan Ph: +675 340 4392 Mob: +675 7100 2028 Web: http://www.lexacorp.com.pg