<div>
Where are you putting this value?<br />
<br />
Have you tried: &nbsp;=Currentproject.fullname
</div>


Where are you putting this value?

Have you tried:  =Currentproject.fullname

<div>
text box, source code<br />

</div>


<div>
I tried putting your code in the text, report footer. &nbsp;It did not work
</div>


I tried putting your code in the text, report footer.  It did not work

<div>
strange, works for me.<br />
<br />
Try this. &nbsp;Replace the textbox with a label (lbl_database).<br />
<br />
Then in the report footers Format event, try this:<br />
<br />
Private Sub ReportFooter_Format(Cancel<wbr /> As Integer, FormatCount As Integer)<br />
<br />
&nbsp; &nbsp; Me.lbl_Database.Caption = CurrentProject.FullName<br />
&nbsp; &nbsp; <br />
End Sub
</div>


strange, works for me.

Try this.  Replace the textbox with a label (lbl_database).

Then in the report footers Format event, try this:

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)

    Me.lbl_Database.Caption = CurrentProject.FullName
   
End Sub

<div>
Are you displaying your report in Preview or Report or Layout view?
</div>


Are you displaying your report in Preview or Report or Layout view?

<div>
Preview<br />
<br />
Still getting an error. &nbsp;See exactly what I have entered and the message received<br />
<br />
Private Sub ReportFooter_Format(Cancel<wbr /> As Integer, FormatCount As Integer)<br />
&nbsp; &nbsp; Me.lbl.Database.Caption = CurrentProject.FullName<br />
End Sub<br />
<br />
Error Message received “ &nbsp;A custom macro in this report has failed to run, and is preventing the report from rendering.”<br />
&nbsp;
</div>


Preview

Still getting an error.  See exactly what I have entered and the message received

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
    Me.lbl.Database.Caption = CurrentProject.FullName
End Sub

Error Message received “  A custom macro in this report has failed to run, and is preventing the report from rendering.”
 

<div>
<div class="content wysiwyg-content">
I have used the code below to insert the database table name in a report, but it is not working in Access 2007. &nbsp;Can someone please tell me the new code to use.<br />
<br />
=[CurrentDb].[Name]
</div>
</div>


I have used the code below to insert the database table name in a report, but it is not working in Access 2007.  Can someone please tell me the new code to use.

=[CurrentDb].[Name]

Adding filename and path on a report in Access 2007

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.