=Now() Function in Footer

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

Karen

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 label or text
box. Actually, what would that be considered? A label
or a text box? Anyway, I want to temporarily change that
label/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?

Thank you, Karen
 
Why don't you just replace it with...

= "September 27, 2004"

and run the report.

Then replace it with...

="October 5, 2004"

and then run the report.


Am I missing something?

Rick B
 
It's a textbox! 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
 
Thank you for your help - I did exactly what you said and
I ran the report and it's producing the error message -
#Error
-----Original Message-----
It's a textbox! 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

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


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 label or text
box. Actually, what would that be considered? A label
or a text box? Anyway, I want to temporarily change that
label/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?

Thank you, Karen
Click to expand...


.
Click to expand...
 
#Error means you have an error in what you entered. Recheck what you did;
what I gave you works so you could not have done exactly what I said.
.... Did you delete Now()
.... Did you start the expression with an equal sign
.... Did you use square brackets around "Enter Report Date"
.... Are four "m"s and two "d"s with a space between
.... That's two double quotes around the comma and it's comma space
.... Are there four "y"s

You could just copy and paste what I gave yo into the control source
property of the textbox.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Karen said:
Thank you for your help - I did exactly what you said and
I ran the report and it's producing the error message -
#Error
-----Original Message-----
It's a textbox! 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

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


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 label or text
box. Actually, what would that be considered? A label
or a text box? Anyway, I want to temporarily change that
label/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?

Thank you, Karen
Click to expand...


.
Click to expand...
Click to expand...
 
Thank you again - Actually, that's what I did - I did a
copy and paste into the control source property of the
textbox and it's still producing an error.

HELP!
-----Original Message-----
#Error means you have an error in what you entered. Recheck what you did;
what I gave you works so you could not have done exactly what I said.
.... Did you delete Now()
.... Did you start the expression with an equal sign
.... Did you use square brackets around "Enter Report Date"
.... Are four "m"s and two "d"s with a space between
.... That's two double quotes around the comma and it's comma space
.... Are there four "y"s

You could just copy and paste what I gave yo into the control source
property of the textbox.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Thank you for your help - I did exactly what you said and
I ran the report and it's producing the error message -
#Error
-----Original Message-----
It's a textbox! Open your report in design view and select the textbox. Open
properties and go to the Data tab. Delete Now() from
Click to expand...
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
Click to expand...
the
report date. Enter
it like this:
1/25/05
The textbox will then show January 25, 2005

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


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 label or text
box. Actually, what would that be considered? A label
or a text box? Anyway, I want to temporarily change that
label/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
Click to expand...
sets
up
a parameter value. How can I make this (what I thought
would be) a simple task happen?

Thank you, Karen


.
Click to expand...
Click to expand...


.
Click to expand...
 
Karen,

I just tried the following expression in the control source property of a
textbox in a report's footer in Access97, Access2002 set for 2000 and
Access2002 set for 2002 and it worked in all cases --
=Format([Enter Date],"mmmm dd"", ""yyyy")

Are you sure you are doing it correctly? Post the error number and the error
message.
 
Back
Top