Tài liệu Print Labels and Control the Order in Which Records Will Be Printed ppt

10.6 Print Labels and Control the Order in Which Records Will Be Printed

I need to be able to have my application print labels for my user's customer list.

Sometimes my user needs to print labels based on the postal code, and other times he

needs to print labels alphabetically by company name. How do I do this at runtime?

Technique

To accomplish this task, you will use the Report Expert to create mailing labels. You then

will use code to update the sort order at run-time.

Creating the Mailing Labels

To create the mailing labels, you create a new report and choose Mailing Labels for the

type of Expert to use. You then fill in the Data tab, which uses Customers for the table,

and grab the following fields: CompanyName, ContactName, ContactTitle, Address,

Formula (@CityRegionPostal= { Customers.City} & ", " & { Customers.Region} & " "&

{ Customers.PostalCode} ), and Country. You can see how this will look in Figure 10.22.

Figure 10.22. Fields that will be used in the mailing labels.