General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only