More Information on a Label Than Will Fit

[kshadden]

I have a label report that has more information than will fit on the label stock. I used the label wizard to create the report. There are 3 field on the label: Name, Address, and Information. The information field is text field and sometimes the field contains more information than will fit on the label. When I use yo for the Can Grow Property the label cuts off at the end of the label. Whe this property is Yes the field information continues on to the next label without formating to that label (some of the text is on the line between labels). Is there a way to format so the adden information will format correctly on the next label?

 

[dhookom]

I think you will need to
-buy bigger labels
-use a smaller font
-enter less information
-live with truncation
-visit

http://www.lebans.com

for code to automatically adjust the font based on filling the space available.

Duane
MS Access MVP