How to limit lines on form (being pulled from single field in data source)

Greg Iverson

• July 25, 2018 16:07
• Edited

Hi all!

I have a simple 4x6 label form. I have several fields that pull data from a database. It's set up like this:

FIELD1     FIELD2    FIELD3

FIELD4

1-3 are single pieces of data, but field 4 contains MULTIPLE pieces of data with a <CR> in front of each entry to allow multiple entries within the same field.

Here's the database:

FIELD1;FIELD2;FIELD3;<CR>FIELD4<CR>FIELD4<CR>FIELD4<CR>FIELD4

Everything works great and each entry from FIELD4 gets it's own line until there are more "FIELD4" lines than can fit on the label, after which they are simply LOST as it doesn't move onto a separate page.

What can I do to somehow specify the max number of lines before moving to a new page?

I need to use this "<CR>" method to have a single field, as I don't want to have to create a SEPARATE field for each line...

Thanks much!

-Greg

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • July 27, 2018 23:07

  The data will not move onto a separate label. Have you tried setting the field as a paragraph field and enabled Auto Size so the font size will shrink to make sure it all fits on the same label.

   

  0

Please sign in to leave a comment.