View Single Post
Old 06-26-2009, 12:37 PM   #2 (permalink)
Dragoen
TSF Enthusiast
 
Dragoen's Avatar
 
Join Date: Apr 2009
Location: Harrisburg, PA
Posts: 1,024
OS: Windows Vista Home Premium (6.0, Build 6001)

My System

Re: Ms Access Date and Time

Hi James,

Probably the easiest way is to create a text box for date and a text box for time if you want that shown also. In the Control Source property for the text boxes put "=Now()" without the double quote marks. Then in the Format property for each text box, select the desired Date or Time format from the list. Be aware, that Access uses the Windows Regional settings for these date and time displays so if the end user has different formats for their dates and times, the displayed date and time will look different than yours.

HTH,
__________________
Dragoen
=========================================================
Just because we can, doesn't mean we should...
Dragoen is offline   Reply With Quote