Report Description Property

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If you select a Report in Access you can right click on it and open a
Properties dialogue. Under this dialogue there is a Description field. I have
a form where I display some of the reports in my MDB in a list box, and I am
wondering if it might be possible somehow to reference the description that I
entered under the Properties dialogue beside the Name of the report.

Thanks,
Graham
 
AlwaysFroosh! said:
If you select a Report in Access you can right click on it and open a
Properties dialogue. Under this dialogue there is a Description field. I have
a form where I display some of the reports in my MDB in a list box, and I am
wondering if it might be possible somehow to reference the description that I
entered under the Properties dialogue beside the Name of the report.
Click to expand...


You can retrieve the Description property of a report by
using a function like:

Public Function GetDescr(ReportName As String) As Variant
Static db As Database

If db Is Nothing Then Set db = CurrentDb()

On Error Resume Next

GetDescr =
db.Containers!Reports.Documents(ReportName).Properties!Description

End Function

Then, use that in the list box's rwo source query.
 
Thanks Marchall, that's exactly what I was looking for. I already wrote a
function, I just didn't know how to access the description. Perfect!

Graham
 
Back
Top