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


> 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