Xref: alice comp.databases.oracle.tools:34752 Path: alice!news-feed.fnsi.net!netnews.com!feeder.via.net!newshub1.home.com!news.home.com!news.rdc1.nj.home.com.POSTED!not-for-mail From: "Paul Dorsey" Newsgroups: comp.databases.oracle.tools References: Subject: Re: reports - unwanted fields Lines: 23 X-Newsreader: Microsoft Outlook Express 4.71.1712.3 X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Message-ID: Date: Fri, 29 Oct 1999 01:02:05 GMT X-Complaints-To: abuse@home.net X-Trace: news.rdc1.nj.home.com 941158925 24.5.99.45 (Thu, 28 Oct 1999 18:02:05 PDT) NNTP-Posting-Date: Thu, 28 Oct 1999 18:02:05 PDT Organization: @Home Network 1) Place a frame around each of the fields that could be null. 2) Make the frames vertical variable. 3) Put a format trigger on each of the fields to return FALSE if the field is null. -- Paul Dorsey Dulcian, Inc. www.dulcian.com 212 595 7223 P.S. If you would like to talk to Dulcian about a salaried position on our team, please call me. We have openings in NJ for developers. Brian Howard wrote in message ... >I am trying to make a form for mailing labels. The clients table has >address1,address2,address3 which is needed for a mailing label. If any of >these fields are null then it still prints a blank line. How can I make it >ignore the line if it is blank? > >