Hi Michael, First of all, you can never have bold or underline codes inside a formula. It seems like it would work, and it looks like it would work, but it won't work. As you see, it kills the formula. :-(
There is no *simple and straightforward* way to bold or underline text in a field via a formula. There is a very convoluted method for doing it which was demonstrated in the old STE Manager database. As I recall it involved creating a panel to hold the Bold On/Off and Underline On/Off codes in a series of A1A1 fields. The fields were then populated by importing a carefully crafted merge file created in WordPerfect. You then had to link to this panel and concatenate these fields with your data to get the codes into the field via the formula. All in all a clever workaround but a real pain in the pumpkin to implement. It would be nice if we had functions like bold[text] or underline[text] to do this, or if the bold and underline codes inside a formula definition worked but . . . How badly do you want to do this? Tim Rude ----- Original Message ----- From: "Michael Iannantuoni" <[EMAIL PROTECTED]> To: "Dataperfect Mailing List" <[EMAIL PROTECTED]> Sent: Sunday, August 20, 2006 3:57 AM Subject: [Dataperf] Bold Text question > In the Contacts panel of my Advertisers/Subscribers for our Village > Magazine, I have an A7A2::C field which is normally blank but displays > "Payment Overdue" when certain conditions in the linked Payments panel > are met: I set this up by entering the formula for testing the > conditions and the text message in the Define Field - Define Field > Formula (Option 2) screen and it works fine with plain text but I would > like this text to be Bold so that it stands out and here I have a problem. > > If in the Define Field - Define Field Formula (Option 2) screen if I > select the text message, or even just part of it, and press F6, it shows > up as Bold on screen but when I exit this screen, I get a "Word Not > recognised" error message from DP. When I press enter or click on "OK", > I am returned to the previous Define Field screen and can return to the > panel but the Field does not display at all under any conditions. Going > back into Define Field - Define Field Formula (Option 2) and deleting > the Bold codes corrects this but I am again left with plain text. > > I am obviously doing something wrong but I am not sure what. Is there a > way to achieve what I want? > > TIA > > Michael > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
