Can't put date on report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pele - 28 Oct 2004 22:14 GMT

I created a report in Access and tried to include the date
at the bottom of the report. I added a textbox with the
control source of =Now() (and the format was medium date).
The control box is in the Page Footer section of the form.

Unfortunately, the form doesn't allow me to move off the
design view to the preview. But once I delete the textbox
with the date, then it shows me the report in preview.

By the way, I also added another text box in the report to
display the page number and that works fine.

Can anybody tell me why the the report won't run if I try
to show the date. Thanks.

Pele

Reply to this Message

AlCamp - 29 Oct 2004 04:39 GMT

Pele,
Your =Date() should work.
Make sure you didn't name the field "Date" or "Now"... those are reserved
words in Access.
Try this... name that field [DateOfPrint] and use =Now()
OR
name that field [DateOfPrint] and use =Date()... and if it still fails
as you describe, there must be a problem somewhere else.

If you only need a date value, use =Date() instead of =Now(). Date()
stores the Date and Now() stores the Date and Time.
hth
Al Camp

>I created a report in Access and tried to include the date
> at the bottom of the report. I added a textbox with the
[quoted text clipped - 12 lines]
>
> Pele

Reply to this Message

Pele - 29 Oct 2004 15:53 GMT

Unfortunately it didn't work, so something else must be
going on.

All I wanted to do was just create an unbound textbox with
a Control source that says =Now() or =Date(). I don't know
why it won't work.

Pele

>-----Original Message-----
>Pele,
[quoted text clipped - 32 lines]
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.782 / Virus Database: 528 - Release Date:

10/22/2004

Reply to this Message

Sarah Stockton - 06 Nov 2004 09:43 GMT

go to insert >> date

follow the promts and see if the program will do the work for you. Maybe
that will eliminate whatever you are doing wrong.

> Unfortunately it didn't work, so something else must be
> going on.
[quoted text clipped - 57 lines]
> >
> >.

Reply to this Message