I'm making some mailing labels here at the lab for to send out some christmas cards (ain't we sweet?). anyways, i've basically got a really simple string for figuring out how to send a card to "Mr. & Mrs. John Doe & Family", but the problem is that we've also got to send one to "Mr. and Mrs. Abraham Reallylonglastname and family" and there's not enough room on those dang little labels to print this out. How do I talk Access into being all nice and just wrapping the text around the box to the next line?
Things I've tried...
Setting can shrink/can grow to all possible combinations
Adjusting the size of the box relative to the size of the label
Smaller fonts (made everything illegible)
The code for my little monstrocity ("hoh" means "head of household" and [children] is a field where thier childrens names are compiled from another table) follows. With code like this, I pitty the man who takes my job after me.