Using field values in Caption Field / Access 2003

Question

I have a few access reports that routinely get printed to PDF. I've noticed the default filename of the PDF file is the 'caption' value of the report. I can change this value in design view. I would like to make it dynamic and return field values in the title. Is this possible?

abach · Answer

You can use the OnOpen event to write code that will change the title of the report. If you'd like, just reference a field's value and point it to the report title. If you need a sample, let me know

NemesisDB · Answer

sample would be great :)

NemesisDB · Answer

bump

abach · Answer

Try something like the following if your Title is in the Report Header.  [value] is the field name   Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer) lblTitle.Caption=Me.[value] End Sub   Let me know if this does not work

NemesisDB · Answer

not sure if you're still monitoring but that did not work.  said run-time error '424':  Object required

abach · Answer

Sorry for the delay - I've been overwhelmed with calls lately.   You need to have a label named lblTitle for the code to work.

abach · Answer

A real nice feature to trap for no records in a report is to use the NoData event in the report. Just type the following code:

    MsgBox "No Records to Report"
  Cancel = True

If there are no records a message box appears and the report closes.

NemesisDB · Answer

thanks again ... I can think of a couple of places where that will be useful :)

NemesisDB · Answer

got it ... completely my bad.  I actually had a problem in a source query.  No records meant no value which led to the error.   Thanks again :)     What's interesting is that it only works if I print from print preview.  If I print directly, the file name (and presumably caption) doesn't change.

Productivity Software

Was this post helpful?