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 ) ) )