I tried that - but, it didn't work. Maybe its an issue with the EOF thing. Also, in reading your reply - I saw there was a typo in the "IIF" - which I did fix - but it still didn't work.
Am going to try a different tack - and try creating an extra field that designate (via a Boolean) whether an option is a reference to a Sub-menu level. Although, this will still be dependent upon the "DynamicCurrentControl" - and am hoping I can still make it work... -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stuart Dunkeld Sent: Wednesday, July 15, 2009 9:36 AM To: [email protected] Subject: Re: Password Util, Grid & Buttons... DynamicCurrentControl is a strange property, which requires quoted strings as arguments. Try this: DynamicCurrentControl = [=iIIF(Eof("Menu_Pass3"),"Thisform.grdSubMenu.Column3.Dummy_Txt", "Thisform.grdSubMenu.Column3.Sub_Opt")] --stuart On Wed, Jul 15, 2009 at 2:24 PM, Kurt Wendt<[email protected]> wrote: > I actually DID try the Sparse option - but, that requires me to go to > that specific Cell to properly show what's in it - whereas I want ALL > the cells in that column to show that button - if it is in fact > representing a sub-menu option. > > So - for more specifics. I have 2 controls for a column in the Grid. One > is text, and the other is a button. I initially set the CurrentControl > to the text. However, in the DynamicCurrentControl - I am attempting to > have it select the proper control to be the button IF the condition is > met. So, in the DynamicCurrentControl I have it set to: > > > However, when it runs - it doesn't not display the Button - it only > shows the text. And, if I set the initial control to the button - then > ALL the rows show a button in that Cell and not the blank text - as > opposed to showing a button ONLY if its truly a sub-menu option. > > Anyway - thanks in advance for your input Dave! > > -K- > > -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Dave Crozier > Sent: Wednesday, July 15, 2009 4:34 AM > > > Kurt, > When yu say not working what do you mean. Nod displaying, not doing the > correct thing? > > It may well b as simple as the "sparse" setting for the column. > > but until you give us info we won't be able to help. > > Dave Crozier > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf > Of Kurt Wendt > Sent: 14 July 2009 22:19 > > ...I am building a Password Utility, to allow our client to control > which > users can access what parts of the system (built in VFP9). I've > extracted the main data from the Menu system data file - and I am using > that data - along with Usernames/ID's to create this access utility. > > The problem is that in the one grid - if the current row is actually the > name of a sub-level menu, I want to have a button displayed in the Grid > cell vs. having that cell blank or contain empty text. So, within that > column I have a text field and a Button field. I even tried using the > "DynamicCurrentControl" of the column to try and control it - by link to > another occurrence of the table I am looking at. If its actually a > sub-level menu option - the link to table will have a bunch of data (via > Set Relation) where as it will be Empty/EOF() if it's a menu command > option instead of a Sub-level menu option. However, I must be using the > "DynamicCurrentControl" incorrectly - since I can't get it to work > right... > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a1405578...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

