Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Access

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-03-2006, 06:24 AM
Novice
 
Join Date: Nov 2006
Location: saratoga Texas
Posts: 9
kfoyil
Default 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
Reply With Quote
  #2  
Old 12-04-2006, 10:07 AM
Advanced Beginner
 
Join Date: Dec 2005
Posts: 99
StepUP
Default

Use "General Date" as the format option and make sure the text box is wide enough to accomadate the full date display.
__________________
John F
Reply With Quote
  #3  
Old 12-04-2006, 07:13 PM
Novice
 
Join Date: Nov 2006
Location: saratoga Texas
Posts: 9
kfoyil
Default

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
Reply With Quote
  #4  
Old 12-05-2006, 03:50 PM
Advanced Beginner
 
Join Date: Dec 2005
Posts: 99
StepUP
Default

Then Format the result of the timeserial function.
__________________
John F
Reply With Quote
  #5  
Old 12-05-2006, 08:02 PM
Novice
 
Join Date: Nov 2006
Location: saratoga Texas
Posts: 9
kfoyil
Default 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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filename displaying with image Rob Parker Forms 2 01-13-2010 02:05 PM
Displaying a picture on a form kydbmaster Forms 4 04-04-2009 05:54 PM
form not displaying fields ashiers Forms 0 09-19-2008 05:02 AM
Displaying a PDF in a Form Chaz Forms 0 08-07-2006 01:26 PM
Displaying data formatted Zoroxeus Forms 0 03-14-2006 06:45 PM


All times are GMT -8. The time now is 08:23 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.