Can't put date on report

  • Thread starter Thread starter Pele
  • Start date Start date
P

Pele

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
 
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
 
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,
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
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
Click to expand...


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.782 / Virus Database: 528 - Release Date: 10/22/2004


.
Click to expand...
 
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.


Pele said:
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,
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
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
Click to expand...


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.782 / Virus Database: 528 - Release Date: 10/22/2004


.
Click to expand...
Click to expand...
 
Back
Top