• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 492
  • Last Modified:

time only column in Access Web database

in access 2010 i can add a date/time and set the format to time only. in an access web compatible database i am having trouble adding the same time only column. searching the internet has not giving any results on how to do this.

Cheers,
Brendan
0
brendanlefavre
Asked:
brendanlefavre
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Set your field to a Date/Time data type and set the Format property to Short Time.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
0
 
brendanlefavreAuthor Commented:
in a web database, i'm not able to set the format of Short Time. Is there a hidden menu?


date-time.png
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Humm.  I haven't worked with a 'web database', but that list does not make sense.

Can you type in Short Time ? or hh:nn ?

mx
0
 
peter57rCommented:
Choose general date for the table.
In your form you can select one of two time formats for the display.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now