date and time field

[AD]

2 issues:

1. I want the start time to automatically enter itself. I know that I can do
this by entering: now() view the date is displayed as : 10/4/2008 10:14:43
AM. I don't want the date to display this way, but in Saturday, October 04,
2008 10:14:43 AM. HOW DO I CHANGE OR WRITE THIS in the default value section?

2. The above format automatically enters the time stamp.In this instance I
want to manually enter the date and time stamp by selecting the date picker
picker. I want to be able to manually enter the time stamp in the same
format: Saturday, October 04, 2008 10:14:43 AM.

How do I accomplish this?

 

[Ken Snell \(MVP\)]

2 issues:

1. I want the start time to automatically enter itself. I know that I can
do
this by entering: now() view the date is displayed as : 10/4/2008 10:14:43
AM. I don't want the date to display this way, but in Saturday, October
04,
2008 10:14:43 AM. HOW DO I CHANGE OR WRITE THIS in the default value
section?

You don't use the Default Value property to affect the display format. Use
the Format property instead. Set that property to the desired display format
that you want.

2. The above format automatically enters the time stamp.In this instance I
want to manually enter the date and time stamp by selecting the date
picker
picker. I want to be able to manually enter the time stamp in the same
format: Saturday, October 04, 2008 10:14:43 AM.

I'm confused... you want to use the datetime picker to select the date/time,
but you then want to manually enter the date/time value? Don't you do one or
the other? Regardless, see my answer to your first question above.

 

[ldiaz]

I think you can use:
Me![Text1] = Format(Now(), "MMMM DD HH:MM:Ss Am/PM")

Thanks
LD

 

[AD]

Let me clarify what I am trying to do. I am creating a radio dispatch data
base. I set one field for the start date and time. That field is where I have
the now() in the default value. The issue on this is how I want it to appear.
I want it to show the day, month, day and year as Saturday, October 04, 2008
10:14:43 AM. This information is automatically entered as the rest of the
fields are filled out.

The second date and time field will be for the end of date and time. Since
the now() automatically enters the most currently information and not when
the call is being closed out I need to figure out what I need to do to
manually select the day with the date picker with the date and current time
of the close of the call. Example, Saturday, October 04, 2008 10:30:00 AM

 

[Ken Snell \(MVP\)]

As I said, use the Format property of the field to set the display format
that you want. How you display the date/time value does not change how
ACCESS actually stores the date/time value in the table, nor how you enter
the data.

Enter this for the Format property of the fields:
dddd mmmm d", "yyyy hh:nn:ss ampm

As for "manually" entering the current date and time in a field, you can use
keyboard shortcuts. When you're in the field, first press Ctrl+; (enters the
date) then press the space bar to enter a space then press Ctrl+Shift+;
(enters the time). ACCESS will properly store the date/time value, and if
you've set the Format property the way you want, the value will be diplayed
the way you want when you click away from the field.