Truncating characters to fit the Inventory tag Label

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
You can truncate it by not allowing the text box to grow.

--
Duane Hookom
MS Access MVP


Lee said:
Hello,
I want to print a label model (5160). There is one field with very long
Click to expand...
text. I want to truncate it in order to fit the formart of this kind of
label. Any suggestion would help.
 
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,
Click to expand...

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.
 
Back
Top