I have developed an order tracking program using Access. I export our daily orders out of an accounting program and drop the orders into an Access database for tracking purposes. I want to print barcode labels for each order based on the invoice number. When using the label wizard, the wizard only allows me to select one font of type and one type size for the entire label. I want three fields on the label plus one word “UPS”. On the first line of the label I want the following two fields [INVOICE_No] [INVOICE_No2]. The first invoice field I want in font CODE3OF9 in 20 point size, I know I have to put an * at the start and an * at the end to make a barcode. The second Invoice No2 I want in standard 14 point Arial. On the second line is [Purchase_Order], again I want it in 20 point CODE3OF9 followed by the word UPS. This line is used to scan into our UPS courier system. (We import the orders into the UPS system daily, based on the new P.O. number). We are using a standard Avery laser label #5160. If this is possible, I would appreciate any help you can give me. Please keeping in mind when answering, I am only self taught and mainly use the wizards and some marco in developing this database. I have already created the query to get the specific fields I want, now I need to create the report based on this query. Thanks very much, D. Irvine
