Date/Time Stamp in a Report

[Susan Bricker]

Greetings. I have a report (actually all of my reports in an MDB) that
I want to date/time stamp at the bottom.

Previously, I had used the builtin function of Now(). I thought that
would give me a date and time value in the format: "month day, year
hour:minutes:seconds". However, I noticed that only the date was
printing (e.g.; January 23, 2006). This is in Access 2000.

BTW ... The way I display the date/time stamp in a text field with the
ControlSource set to "=Now()" in the properties window while in Design
Mode.

So ... in order to get the time value added to the display I changed the
ControlSource to

=Date() & "...." & Time()

Funny thing, though ... the time (hh:mm:ss) value changes on every
printed page. I would have like to keep the time value the same for the
entire printed report.

I am running this on Access 2000.

1. Any ideas why this is happening?
2. Is there a way to get the same timestamp on every page of a printed
report?

Thanks, much.
Sue

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***

[fredg]

On 22 Dec 2006 14:27:58 GMT, Susan Bricker wrote:

Greetings. I have a report (actually all of my reports in an MDB) that
I want to date/time stamp at the bottom.

Previously, I had used the builtin function of Now(). I thought that
would give me a date and time value in the format: "month day, year
hour:minutes:seconds". However, I noticed that only the date was
printing (e.g.; January 23, 2006). This is in Access 2000.

BTW ... The way I display the date/time stamp in a text field with the
ControlSource set to "=Now()" in the properties window while in Design
Mode.

So ... in order to get the time value added to the display I changed the
ControlSource to

=Date() & "...." & Time()

Funny thing, though ... the time (hh:mm:ss) value changes on every
printed page. I would have like to keep the time value the same for the
entire printed report.

I am running this on Access 2000.

1. Any ideas why this is happening?
2. Is there a way to get the same timestamp on every page of a printed
report?

Thanks, much.
Sue

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***

If you wish the current date and time to print on the report, then
=Now() is the correct expression. You somehow must have set the Format
property of that control to show just the date portion. Set the format
of the control to :
mmmm d, yyyy hh:nn:ss AM/PM

Since Now() returns the current date and time, it will increment the
time value each time the control is printed.

To show the time as of the first instance the report is run, leave
that control source blank.
Code the Report Header Format event:
Me![ControlName] = Now()

As the Report header is run just once, the time on each page will
remain the same.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail