Filename in Report Footer 3

[shniderph]

Is there a way to automatically put the database filename in a report footer? Any ideas other than just typing it in? Thanks!

 

[WP]

Create a text box in your footer. Set the Control source to =DBName

Now add the function :

Public Function DBName() as String

DBName=Currentdb.Name

End Function

Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out my website !

 

[DougP]

Cool Bill,
I've wanted to do that also.

How about a star man!!!!
;-)


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.