Erica,

You can use a formula on the field that will change the font color, replace the data with a statement, or whatever is the best alert using the "Length" string function, like this:

If Length ({Objects.CreditLine}) > 25 then crRed
Else crBlack

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Ella Rothgangel
Sent: Tuesday, November 13, 2012 1:10 PM
To: [log in to unmask]
Subject: using tms to determine label length

We currently export tombstone data from tms into Word, then from Word to Quark, to make labels.

At the same time, the curator is writing extended label text that is edited in education, and then added to the Quark document just prior to label production.  The final label text is then copied back into tms and a pdf of the label is added to media.

Lately we have run into problems where the edited label text is too lengthy for the label and needs to be cut.  This has prompted us to ask, if the label copy were written into a field in tms (say text entries), could the curator run a report right then that would show if the copy would be too large for the label?  I have played around with Crystal to try and come up with a solution but without success.   Has anyone faced this problem and come up with a tms fix?

Thanks,

Ella


Ella Rothgangel
Collections Information & Imaging Administrator
Saint Louis Art Museum
One Fine Arts Drive, Forest Park
St. Louis, Missouri  63110
314.655.5408

To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.