Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid-Lock, setting the controlsource
Message
From
14/09/1999 04:23:56
 
 
To
13/09/1999 12:57:57
Butch Wright
Tim Tusing Enterprises Inc
Lacrosse, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00264061
Message ID:
00264349
Views:
16
Hi Butch.

>> what I want is a 2 column grid that shows the text in one column, and depending on the logical flag for each record, will either display 'Paid' or 'Unpaid' in the other column. <<

Try this.

Select the grid column to display the logical field in the drop down list at the top od the property sheet. Now click on the data tab. Select ControlSource. Click on the little function (fx) button to the left of the drop down list and type the following in the Expression edit box:

IIF(MyTable.LogicalField, 'Paid', 'Unpaid')

where MyTable is the grid's RecordSource and LogicalField is the logical field in that table. Click on OK.

Keep in mind, that if you do it this way, you that column in the grid will be ReadOnly.

Marcia
Previous
Reply
Map
View

Click here to load this message in the networking platform