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