Calendar Time

T

T23459

I have two seperate questions regarding Access 2000.

1. I have a field called ContactTime. Currently the format chosen is
medium time.
I would like system to use the 12 hr clock system. When I type 2.30 (to
mean 2.30pm),
the result is actually 2.30 AM.


2. I have inserted the Calendar (ActiveX) in a form. Unfortunately it does
not show the current date reflected in the depressed button of the calendar
when it is opened. Is there a way to create some code to allow the calendar
to recognize the current date by default when it is opened.

Any help is much appreciated.
 
C

Cowji

T23459 said:
I have two seperate questions regarding Access 2000.

1. I have a field called ContactTime. Currently the format chosen is
medium time.
I would like system to use the 12 hr clock system. When I type 2.30 (to
mean 2.30pm),
the result is actually 2.30 AM.


2. I have inserted the Calendar (ActiveX) in a form. Unfortunately it does
not show the current date reflected in the depressed button of the calendar
when it is opened. Is there a way to create some code to allow the calendar
to recognize the current date by default when it is opened.
Click to expand...

I used the following which works.

Private Sub Form_Load()
Calendar.Value = Date
End Sub
 
Top