[AccessD] Displaying SQL Server Time(7) in Access

I don't think you can and leave it editable.  SQL Server date/time is a
higher precision that Access's version.  You could fake it by displaying
the time in a label and putting a transparent, unbound textbox on top of
the label.  Then use code to parse out the value and modify the SQL Server
field.


Charlotte Foust

On Tue, Jun 5, 2012 at 6:38 PM, jwcolby <jwcolby at colbyconsulting.com> 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?
>
> --
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
>
>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>
>
>