Page footer

  • Thread starter Thread starter Ellen
  • Start date Start date
E

Ellen

Hello,
I'd like the page footer to contain only the month and
year, not the month, day and year as what's in the
defaults.

Thanks in advance for help for this question.

Ellen
 
Ellen,

Like before, select the control displaying the Date (or create a new one),
leave the Control Source property as is (=Now()), and change the Format
property on Format tab of the Properties pop-up window to one of the
following:
mmmm yyyy
mmm-yyyy
mm/yy
mm/yyyy
etc. depending on the format you wish.

HTH,
Nikos
 
1. Open the report in design view.

2. Right-click the date text box in the footer, and choose Properties.

3. Set the Format property of the text box to:
mmmm yyyy
 
Thanks, Allen! Now, can you tell me how to put the month
and header in the report header?

Ellen
 
Just copy the textbox with the formatte date in the report footer, and paste
it in the report header, or create a new textbox in the report header, set
its control source to =Now() and change the format like you did before.

HTH,
Nikos
 
Back
Top