Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement