Here's my situation:
I have a back end SQL table that I access via Access Web App/SharePoint and an Access 2013 Front End that I use to create reports, forms, etc.
I have a linked table with time fields in it, [Start Time] and the properties are set to Short Time. When I open up this linked table in my FE, the [Start Time] shows text string 17:30:00.000 instead of 5:30 PM.
Now I'm using that field in a form and all the times are showing text string and formatting the field in the properties does nothing.
How can I display this text string to a medium time format?:banghead:
I have a back end SQL table that I access via Access Web App/SharePoint and an Access 2013 Front End that I use to create reports, forms, etc.
I have a linked table with time fields in it, [Start Time] and the properties are set to Short Time. When I open up this linked table in my FE, the [Start Time] shows text string 17:30:00.000 instead of 5:30 PM.
Now I'm using that field in a form and all the times are showing text string and formatting the field in the properties does nothing.
How can I display this text string to a medium time format?:banghead: