i have a combo box in a form whose row source is a table call workstatus
workstatus looks like the following
when i display this in the report, it displays the numbers and not the text
how do i get it to display the second column in the report. I tried setting it as a combo in the report and setting no of col to 2 and col widths to 0";1" but that doesnt work
add the workstatus table to the query (i assume there's a link between the number field in work status and the number field in tblworkorder - if not, create one) and add the text/description field from the workstatus table to the output of the query. add this new field in place of the number field in your report.
Though you've been given the solution, in case you really have to use a combo box instead of the IIF statement, because you have so many data in the combo box, this is what I did. Do not assign the 0" width for columns you don't want to show. Assign a very thin width like .001" so you don't lose any column count.