Display Database Name in Report

A

Angela Lesner

How can I display the database name in a Access 2000
report?

For example, if I want to display a report's datasource
(query or table), I type =[RecordSource] in the
properties, data, control source box. I can't figure out
what I type to display a report's database name.

Angela Lesner
OnStar Sales Services Marketing
248-307-4394
 
R

Rick Brandt

Angela Lesner said:
How can I display the database name in a Access 2000
report?

For example, if I want to display a report's datasource
(query or table), I type =[RecordSource] in the
properties, data, control source box. I can't figure out
what I type to display a report's database name.

Angela Lesner
OnStar Sales Services Marketing
248-307-4394


CurrentProject.Name
 
D

Duane Hookom

If you don't want the path, try
=Dir(CurrentDb.Name)
--
Duane Hookom
MS Access MVP


Lew said:
If you don't mind the path, you can use "=CurrentDb.Name"
for the Control Source.

-----Original Message-----
How can I display the database name in a Access 2000
report?

For example, if I want to display a report's datasource
(query or table), I type =[RecordSource] in the
properties, data, control source box. I can't figure out
what I type to display a report's database name.

Angela Lesner
OnStar Sales Services Marketing
248-307-4394

.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top