Microsoft KB Archive/199055

= ACC2000: How to Output Horizontal Lines on Report Using OutputTo =

Article ID: 199055

Article Last Modified on 6/30/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q199055



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SUMMARY
If you output the data in a report, the only controls that are included in the output file are text boxes (for .xls output files), or text boxes and labels (for .rtf, .txt, and .html output files). All other controls are ignored.

This article show you how you can use the String function to output horizontal lines in your report.



MORE INFORMATION
The String function returns the number of characters that you specify for the string. To output lines in a report by using the MyOutputTo function, use the String function as follows:

 Open the report to which you want to add the lines in Design view. Create an unbound text box, and place it on the report in the position where you want to have the line appear. Widen the text box to the length you would like the line to be.

NOTE: Delete the label portion of the text box if you do not want it to appear in the report. In the ControlSource property of the text box, type the following

=String

where is the length of the string and is the repeating character string that you are using.

For example, to print a total of 125 dashes (-) across a report, type the following in the ControlSource property:

=String(125,"-")

 Switch the report to Preview to make sure the line appears where you want it. Close and save the report.  Create a module and type the following procedure: Sub MyOutPutTo

DoCmd.OutputTo acOutputReport, "<ReportName>, acFormatTXT, _        "C:\<OutputFileName>"

End Sub NOTE: For <ReportName>, substitute the name of your report, and for <OutPutFileName>, substitute the name for your output file. </li> Run the procedure from the Immediate window. Note that the report is output with the lines.</li></ol>

Additional query words: inf

Keywords: kbhowto kbprint kbprogramming KB199055

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.