I have a numeric field that has 0,1,2, or 3 as the value. I want the GRID that displays the field to show blank if value is 0, "Text 1" if value is 1, "Text 2" if value is 2, etc. How do I display text in the grid based on a numberic field?Use this as the ControlSource for the column where 'Table' is the alias used as the grid's recordSource and 'Field' is the one the column should be bound to:
( IIF( EMPTY( Table.Field ), '', 'Text ' + TRANSFORM( Table.Field ) ) )