Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    4

    Unanswered: Adding arbitrary text to a report

    Hey guys,

    I have report, which is linked to a link table. This report changes as the file the table is linked to changes.

    Is there any way I can add some arbitrary text (a description of the report) to the beginning of the report, each time it is generated? I know this can be done manually, by converting the report to a word file and adding in the text manually, however as the report changes with each new file I would like to automate the process.

    Can this be done?

    Any ideas??

    Cheers.

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    You could put a label in the header of the report.
    If you are using a command button to print the report,
    change the code to something like this:

    Dim strText as string
    strText = (get your arbitrary text and put it here)
    docmd.openreport, "YourReportName", acviewdesign
    reports!yourreportname.Label1.Caption = strText
    docmd.openreport, "YourReportName", acviewNormal
    Inspiration Through Fermentation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •