avery label problem

[powellm1976]

I was wandering if anyone out there could help me with a label problem. I need to know where I tell the report what kind of avery label I want to print it to and I also need to know if there is a way to make whatever text is in the box automatically adjust itself to fit in the box. Thank you for all your help and let me know if you need additional info.

Thanks

Mark

 

[Pat Hartman]

Use the label wizard to create the labels. It will prompt for the label size. You can choose from a pre-defined Avery label or define your own.

Access doesn't have the same formatting flexibility that Word and Excel do. So there are no options that operate on the entire label. You can center things horizontally by defining a single field the entire width of the form and setting its TextAlign property to Center. There is no way to center vertically. If you want, Access will not print lines that are completely empty if the CanShrink and CanGrow properties of the detail section and all the controls in it are set to Yes.