Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.paradox    |    To crash or not to crash, asks Borland    |    9,834 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 8,216 of 9,834    |
|    Liz McGuire to Jeanette    |
|    Re: Delete When Empty property ?????    |
|    22 Feb 07 11:57:53    |
      From: liz@paradoxcommunity.com              Jeanette,              You can accomplish delete when empty on a calculated field, thusly:              iif(isBlank([table.field]),"","Field Label: " + [table.field])              ...and use an edit field rather than a labeled field. Then the field       label is part of the calculation and if the table field is blank, the       entire calculated field is blank.              Hope that helps,              Liz                     Jeanette wrote:       > PLEASE       > Someone tell me what silly thing I'm doing that prevents this property from       > working on my report.       >       > I have a report for a Construction Engineer - works great!       > It displays the Engineers as- Construction Engineer: Tom Brady       >       > The same data is needed for the Manager of the Construction Engineers except       > the Manager will drive the report by date rather than by Engineer Code.       >       > If I set the property and there is not data the label is not displayed.       HOWEVER,       > once I make the field a calculated one so that the name displays and not       > the code I can't set the property.       >       > Say it isn't so AND I am doing something dumb!!!!       >       > TIA       >              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca