Getting a number to display text (1 Viewer)

Hello,

A quick summary would be that I'm trying to change a 1,2,3 in a table to display NA, Yes, No on a form.

I have an Infopath form with a n/a,yes,no drop down that is dumped into Access. Infopath requires a value be tied to them so it is 1,2,3. So in Access, my table shows the numbers and not the text. I would like to know how to get my access forms to show the text instead. Not sure if I should be setting the field criteria in my query to say if this field is a 1 make it Yes, if 2 make it NO, if 3, make it NA. Or if there is something compeletly different to do.

I found a workaround by going into the query and using Find and Replace but I need this to update itself automatically

Thanks

Use a combobox to display the field, not a textbox. A combobox can bind to one value yet display a different value, but you need to set a few properties.
Post back if any of that doesn't make sense.

Amazing, spent the last couple hours tyring to figure that out and was ready to go home for the night!

Works perfectly.

Thanks a million!

Yeah, you bet!