Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: dan delpuerto
  
 
 
 dan delpuerto
 To: Barbara Peisch
  Where is Barbara Peisch?
 Oceanside
 California - United States
 Barbara Peisch
 Tags
Subject: RE: make certain values invisible in grid
Thread ID: 78194 Message ID: 79049 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Forms
Date: Wednesday, October 12, 2005 2:11:03 PM         
   


Thanks for the comment but I
tried it many times, and it works-
just don't forget the "=" sign before the expression.

=iif(qty>0,vat,"")

Note: In my example, QTY and VAT are fields of a table and not
column names.




> > If this is not yet too late, try changing the
> > controlsource of the vat column to:
> >
> > =iif(qty>0,vat,"")
> >
> > note: this does not need cell formating to hide zero or change "" to
> > 0 (zero) if you want to use it in calculations (with "Z" format
> > qty and vat must be table fields...
> >
> >
> > > Hi,
> > >
> > > On my form I have a grid, with a.o. columns for "article", "quantity" and "VAT%".
> > > The way it is now is that every line in the grid displays the numeric value of the VAT% (19,00 in most cases). This value is stored in the database for each record. I want to change the grid and show the VAT% only when the quantity is <> 0 (without setting the VAT% in the database).
> > >
> > > How should I to this in this grid?
> > >
> > > Regards,
> > >
> > > Gerrit

>
> Did you mean to specify the DynamicCurrentControl property because this certainly won't work with the Controlsource.
>
> -BP
> www.peisch.com


ENTIRE THREAD

make certain values invisible in grid Posted by gerrit broekhusi @ 9/28/2005 10:00:52 PM
RE: make certain values invisible in grid Posted by Jamal Rahal @ 9/28/2005 10:31:27 PM
RE: make certain values invisible in grid Posted by Barbara Peisch @ 9/28/2005 11:34:34 PM
RE: make certain values invisible in grid Posted by gerrit broekhusi @ 9/29/2005 1:30:30 PM
RE: make certain values invisible in grid Posted by Ken Murphy @ 9/29/2005 2:23:12 PM
RE: make certain values invisible in grid Posted by gerrit broekhusi @ 9/29/2005 3:13:58 PM
RE: make certain values invisible in grid Posted by Barbara Peisch @ 9/29/2005 9:39:17 PM
RE: make certain values invisible in grid Posted by Marcia Akins @ 9/29/2005 10:18:24 PM
RE: make certain values invisible in grid Posted by dan delpuerto @ 10/11/2005 4:09:15 PM
RE: make certain values invisible in grid Posted by Barbara Peisch @ 10/12/2005 2:58:10 AM
RE: make certain values invisible in grid Posted by dan delpuerto @ 10/12/2005 2:11:03 PM