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: Gerrit Broekhuis
  Where is Gerrit Broekhuis?
 Holten
 Netherlands
 Gerrit Broekhuis
 Tags
Subject: RE: make certain values invisible in grid
Thread ID: 78194 Message ID: 78963 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Forms
Date: Tuesday, October 11, 2005 4:09:15 PM         
   


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


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