Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. abezuide

    unwanted gaps when null

    lol, work related. Huge database, sorry, can't really say more. I tend to over exagerate too ha ha, only 267 items of which 200 can be null. The report sure looks beautiful now thanks to your help! Inconsistant isn't it? This report builder, once it works without the individual frames, next time...
  2. abezuide

    unwanted gaps when null

    Thanks so much for your help. Yes they were all individual items. Took me two hours to put them all in individual frames lol, but it worked!!!! You are a star!
  3. abezuide

    unwanted gaps when null

    auch, it is a huge report with about 500 fields from 7 tables of which about 300 of the fields can be null!
  4. abezuide

    unwanted gaps when null

    Hi, thanks for the quick answer. Let me explain exactly. I have say six labels with fields in one frame set to vertically variable. a field a b field b c field c d field d e field e f field f like that. Say for instance the field c and d can return without a value, I wrote the code if :field c...
  5. abezuide

    unwanted gaps when null

    Hi, Thanks for your answer. I do have it in a frame vertically elastic, it still won't work. Sob!
  6. abezuide

    unwanted gaps when null

    Hi gurus, I have fields that are sometimes null. I put the code if :database_field is null then return(FALSE); else return(TRUE): end if; in the formate trigger. I anchored them and made the property of the anchor vertically collapsable. Yet, sometimes the fields move up, but sometimes the gap...

Part and Inventory Search

Back
Top