Inserting auto-updating filename as part of footer

  • Thread starter Thread starter Larry Zdanis
  • Start date Start date
L

Larry Zdanis

I can't figure out how to insert teh filename as part of
the footer on each page of my report,
which will update when the filename changes.

My purpose is to include the Revision letter of the
database in the filename, and the filename on each page,
so somebody looking at a printout of the report know
the Rev it came from.

This is an easy thing in MS Excel, or MS Word,
generally done from File_Page-Setup.

It seems like the built-in Access function CurrentdB()
should work, but it gives me an error.

I tried an alternate method, by including the Rev in
a query of a Rev History Table, also in the database,
but it didn't work (I don't know if anything but Forms
or other Reports can be referenced in a report).

Any help appreciated.

LZ
 
LZ,

Turn on your Page Header/Page Footer. Locate in the
Page footer area a blank textbox. Open the properties on
the new textbox and place this code in the field named
[control Source] with a font <= 8pt.

=[Name]

This will place the file name on each page of your
report. One thing I do is place a little more
information on the form that helps me know which product
The report is for with this code:

="Product X: " & [Name]

Notice I placed a space after the semi-colon. that makes
the field more visable.

I hope this helps.

Rob

FYI: if you want to learn more check out www.tek-tips.com
 
Back
Top