Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2006
    Location
    saratoga Texas
    Posts
    9

    displaying the time 12:00:00 AM

    HELP!!!!!

    I can make the time 12:00:00 AM display in a textbox by itsself but when i try to make it display with a date if will not show up in the textbox

    it seems to be there because i can use datediff and my formula works but cant make it display ...


    thanks KEN

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Use "General Date" as the format option and make sure the text box is wide enough to accomadate the full date display.

  3. #3
    Join Date
    Nov 2006
    Location
    saratoga Texas
    Posts
    9
    I have used all the formats availible .... another thing i failed to mention im using the timeserial function to display the date and time...

    thanks ken

  4. #4
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Then Format the result of the timeserial function.

  5. #5
    Join Date
    Nov 2006
    Location
    saratoga Texas
    Posts
    9

    re:timeserial function

    I have used all the formats..every date and time will show up except 12:00:00 AM .. if i go to 12:00:01AM it will show in the Text box control im using or one second before midnight will show up .... .
    I have worked around it by useing seperate text boxes for display(again the midnight time will show up if its by itself in a text box)of the date and time and use a hidden text box with the date and time to do my datediff calculations. this works well but not as clean as i would like.

    thanks ken

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Filename displaying with image
    By Rob Parker in forum Forms
    Replies: 2
    Last Post: 01-13-2010, 05:05 PM
  2. Displaying a picture on a form
    By kydbmaster in forum Forms
    Replies: 4
    Last Post: 04-04-2009, 07:54 PM
  3. form not displaying fields
    By ashiers in forum Forms
    Replies: 0
    Last Post: 09-19-2008, 07:02 AM
  4. Displaying a PDF in a Form
    By Chaz in forum Forms
    Replies: 0
    Last Post: 08-07-2006, 03:26 PM
  5. Displaying data formatted
    By Zoroxeus in forum Forms
    Replies: 0
    Last Post: 03-14-2006, 09:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums