How to make a conditional footnote?

[QedMatt]

Hi everyone,

I have a report that has 3 sort levels, and in the page footer, I am trying to make one of two footnotes print based upon a series of specific values in one of the header's fields.

The report is sorted as:

Report Header
Page Header
Category Header
CourseTitle Header
CourseCode Header
Detail
CourseCode Footer
Page Footer

In the CourseTitle Header, I have a field that reports a CourseNumber. If the CourseNumber is equal to 051719, 051720, 051721 or 051722, then Footnote 1 (a label in the Page Footer) should print in the page footer.

If the CourseNumber is equal to 011310, 011311 or 011312, then Footnote 2 should print in the page footer.

I have set the initial visibility to false, the caption to null, and in the CourseTitle Header's OnFormat event, I check for the values above in CourseNumber. If it is there, it changes visibility to true, writes the new caption, and the footnote prints, else the visibility stays false.

The problem I am having is that it only prints on 1 page, whereas the CourseNumbers appear on separate pages. So, 051719 appears on page 11, and the footnote 1 prints. But 051720 appears on page 12, and the footnote disappears. Note: each CourseNumber will only appear 1 time in the entire report.

Likewise with footnote 2, when it finds 011310 on page 32, footnote 2 prints as expected, but at 011311 on page 33, the footnote disappears again.

I am using Access 2000, and this is a database we just converted from Access 97. This functionality was not something we had in 97 - they just now added it as a requirement.

Does anyone have any ideas or suggestions for getting the footnote to print on each page it is needed, instead of after the first value in the list it finds?

Thanks in advance!

Matt

 

[jdegeorge]

There's a good example of this in Access's help file.

Hope this helps.

Jim "Get it right the first time, that's the main thing..."

 

[QedMatt]

Hi Jim,

Thanks for the tip - one thing, tho. I've been searching the help & can't seem to find what I'm looking for. Can you suggest some keywords to use? I've tried "visible", "visible property", "footnote", etc. Any ideas?

Thanks!

Matt

 

[jdegeorge]

Open HELP and click on the INDEX tab. Search for:

footers in reports, hiding

Jim "Get it right the first time, that's the main thing..."