=Now() Function in Footer

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

Thank you for everyone's help in the past. I posted a
message on the board a few days ago and it's not
resolved. Sorry, but this is driving me nuts and I need
to finish this report. I'll list the postings.

I created a report using the report wizard. When using
the wizard, a footer is created with the =Now() function
and today's date is added to the footer text
box. Anyway, I want to temporarily change that text
box. I have to change the date to (for
example) September 27, 2004 and then print the report.
Then change the date to October 5, 2004 and then print
the report. Etc - When I delete the function, it sets up
a parameter value. How can I make this (what I thought
would be) a simple task happen?

Open your report in design view and select the textbox.
Open properties and go to the Data tab. Delete Now() from
the control source property and enter this instead:
=Format([Enter Report date],"mmmm dd"", ""yyyy")
When you open your report, you will be prompted for the
report date. Enter it like this:
1/25/05
The textbox will then show January 25, 2005

I did a copy and paste into the control source property
of the textbox and it's producing an error. (#Error)

HELP!
 
Hi Karen.
I would change the name of the textbox, and make sure that the format
property is not already set to a different format than what you specify.
Hope this helps.
Fons
 
Back
Top