Getting a number to display text

[RyLane]

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

 

[MarkK]

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.

ComboBox property sheet in Design View
   Data Tab
      RowSourceType = "Value List"
      RowSource = "1;N/A;2;Yes;3;No"
   Format Tab
      ColumnCount = 2
      ColumnWidths = '0";2"'

Post back if any of that doesn't make sense.

 

[RyLane]

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!

 

[MarkK]

Yeah, you bet!