Page footer

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
 
N

Nikos Yannacopoulos

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
 
A

Allen Browne

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
 
E

Ellen

Thanks, Allen! Now, can you tell me how to put the month
and header in the report header?

Ellen
 
N

Nikos Yannacopoulos

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
 
Top