>I have a table with a numeric field 'status' which on forms displays to the user a text message, i.e. if the field=1, the message 'OK' is displayed, 2=Waiting, 3=Delayed etc.
>
>How do I display this associated text in a grid column so that the text messages rather than the numeric field values are displayed?
Bob,
1) Use an optiongroup or dropdown list (display text column, bound num field)control instead of textbox.
2) Make that a calculated field. ie: controlsource = iif(alias.field = 1, "OK",iif(alias.field = 2,"Waiting","Delayed"))
Cetin