I am going to print a huge list of addresses for sending out mail. Some of the names from the name field and address field are too long, and because of the size of the list, it would take too long time to cut them up and add more fields on the label, etc.

Is there any way I can auto adjust the text that is too long, so it would fit the label?

You can set the fields to be deliberately over-sized on your label layout - say 2 lines deep. Then use the SLIDING options to remove blank space from those labels that have regular size names and addresses.

Hi Torbjorn,

But if you want the functionality of a good label program, it isn't for the faint of heart. I would make two suggestions: Invest in a label program (programs such as LabelCreator etc automatically reduce font for overflow (after showing you the overflow in red etc) and you can import your data right into them.

Otherwise, it IS possible. You might check out this discussion requiring a Custom Function Text length in pixels . Once every line is converted to a numeric equivalent, you can script reducing a lines length by reducing the font (one line at a time). Much simpler to let a program (LabelCreator) which has been on the market for 10 years, handle it for you.

UPDTAE: Now this suggestion is based upon fact that you want to reduce the text if it exceeds the line (in width) and that you don't want it to overflow onto the next line (which FileMaker does automatically). Auto-reducing font size isn't easy to handle (on the fly). If all you want is straight addresses, make the text small enough (as suggested) and have it slide.

LaRetta :smile2:

Edited January 15, 200917 yr by Guest
Added Update