Truncating characters to fit the Inventory tag Label

[Lee]

Hello,
I want to print a label model (5160). There is one field with very long text. I want to truncate it in order to fit the formart of this kind of label. Any suggestion would help.
Thanks,

 

[Duane Hookom]

You can truncate it by not allowing the text box to grow.

--
Duane Hookom
MS Access MVP

Hello,
I want to print a label model (5160). There is one field with very long

text. I want to truncate it in order to fit the formart of this kind of
label. Any suggestion would help.

 

[John Vinson]

Hello,
I want to print a label model (5160). There is one field with very long text. I want to truncate it in order to fit the formart of this kind of label. Any suggestion would help.
Thanks,

Use the Left() function as a calculated field, and print that rather
than the text field. E.g. if you have a text field named Verbose and
want to print only 36 characters of it, type

PrintLess: Left([Verbose], 36)

in a vacant Field cell of a query, and print that field on your label.