Date and time control.

[amerifax]

I have set up a form and only want to display the date and time that will appear automatically based on when the record was created. I definitely don't know how to do this.

The format that I'm looking for is: 07/24/13 11:45:44pm
from what I can see I would need two separate fields to accomplish this. I would prefer to only use one if possible. I would like to execute the value within the new record as it is entered. That date and time from that point should never change.

I will want to use the date and time in the future for quality control.
Bob

 

[ypma]

I would put Now() in the default property of the field (date field) at table level . Make sure your field is wide enough for thethe date plus time. The default value only kicks in on new records that are created . Note the AM and PM not there .To the best of my knowledge to acheive that you would have to format the date .= Format(Now, "dddd, mmm d yyyy, hh:mm:ss AMPM") but not in the default property in my example as this is bound . Hope this is some use to you.
Regards

 

[amerifax]

I did get it to work, thank you. And it does show the a.m. and p.m.
But!

If I go into Datasheet View, it only shows the time. But if I enter the field, it will show both the date and the time. Is there a way where I can see both date 7 time at all times. I'm also concerned if I will have the ability to do calculations since the date does not show unless I click in the field.

also on my form design only the time shows unless I click in the field . Then I see both.

Bob

 

[amerifax]

Thanks for the help. I used the word "General" in Format and got it exactly as I needed. I did it in the forum. I would like to know why would I want to do it in the Datasheet View or Forum. It seems if I always want a certain format I would use Datasheet View. If I was planing on using it in different display formats I would stick to forum.

Only a guess.
Bob