time only column in Access Web database

Posted on 2011-10-05
Last Modified: 2012-06-07
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.

Question by:brendanlefavre
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    Set your field to a Date/Time data type and set the Format property to Short Time.

    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)

    Author Comment

    in a web database, i'm not able to set the format of Short Time. Is there a hidden menu?

    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    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 ?

    LVL 77

    Accepted Solution

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

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Learn more about the importance of email disclaimers with our top 10 email disclaimer DOs and DON’Ts.
    Create and license users in Office 365 in bulk based on a CSV file. A step-by-step guide with PowerShell script examples.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now