Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid and different data types in same column
Message
From
02/03/2000 18:01:56
 
 
To
02/03/2000 17:34:19
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00340889
Message ID:
00340901
Views:
22
>Is it possible to do an IIF in a column to display a char value like 'n/a' if the value is 0?
>
>I have a column based on a cursor and the data is numeric. If the value is 0 I want to display 'n/a'...
>
>
>Thanks

Sure is. In your Control source for that column:

yourgrid.ColumnX.ControlSource = 'IIF(yourcondition,"N/A",amount)'
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform