Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: How to Print a Variable-Length Character String

ACC2000: How to Print a Variable-Length Character String

View products that this article applies to.

This article was previously published under Q209001
Novice: Requires knowledge of the user interface on single-user computers.

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

↑ Back to the top

Summary

This article shows you how to print a variable-length character string. You can use this method to print a dotted line (or a line composed of the character of your choice) between two fields of variable length on a report.

↑ Back to the top

More information

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

The following example demonstrates how to print a dotted line between a variable-length name field and a phone number field. To create a variable-length character string, follow these steps:
  1. Start Microsoft Access, and then open the sample database Northwind.mdb or the sample project NorthwindCS.adp.
  2. In the Database window, click Reports under Objects, and then click New.
  3. Click Design View, select the Customers table, and then click OK.
  4. Create two unbound text boxes in the detail section of the report. Modify their properties as follows so that the first text box will display the name and the dotted line, and the second text box will display the phone number.
       Text Box 1
   ----------------------------------------------
   Name: NameDotString
   ControlSource: =[Companyname] & String(88,".")
   CanGrow: No
   CanShrink: No
   Left: 0.3"
   Top: 0.08"
   Width: 2.8"
   Height: 0.17"
   FontName: Arial
   FontSize: 8

   Text Box 2
   -------------------
   Name: Phone
   ControlSource: Phone
   Left: 3.1"
   Top: 0.08"
   Height: 0.17"
   FontName: Arial
   FontSize: 8
  5. Set the Height property of the detail section to 0.25".
  6. Preview the report. Note that the report looks as follows: 
       Alfreds Futterkiste......................030-0074321

   Ana Trujillo Emparedados y helados.......(5) 555-4729

   Antonio Moreno Taqueria..................(5) 555-3932

   Around the Horn..........................(71) 555-8248

↑ Back to the top

References

For more information about creating reports, click Microsoft Access Help on the Help menu, type create a report in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top

Keywords: KB209001, kbinfo, kbhowto

↑ Back to the top

Article Info
Article ID : 209001
Revision : 2
Created on : 6/29/2004
Published on : 6/29/2004
Exists online : False
Views : 265