home bbs files messages ]

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,217 of 9,834   
   Jeanette to Liz McGuire   
   Re: Delete When Empty property ?????   
   22 Feb 07 14:20:45   
   
   From: HarrisJR@bwsc.org   
      
   ELIZABETH!!!   
      
   This was so ELEGANT, it was coooooool !   
      
   Thanks!   
      
   The Mgr wanted a bold Label and then the Name but I will convince the Mgr   
   it's either ALL bold or All regular font...   
      
      
   Liz McGuire  wrote:   
   >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