>Hi there. I use grid. I want to display in grids column values of my character strings in depends from values of table’s field. In table field may store three different values 1,2,3. 1 means – payment, 2 – fine, 3 other pay. I want that be column display, If field = 1 – ‘Payment’, field = 2 – ‘Fine’, Field = 3 – ‘Other pay’. For the start I work with two values of field. In Init method of form I placed next code:
>thisform.grid1.column1.text1.value = IIF(table1.field1 = 1,'Payment','Fine') . But in result I get in column values : 0,1,2. Please help.
In the control source for the grid column, put 'IIF(table.field1=1,"Payment",IIF(table.field1=2,"Fine","Other"))'