Displaying different text in a list box/combo box

[Remster]

Folks

I have a list box containing two columns, one of which is linked to a check box in one of my tables. How to I get "Current version" to display instead of "Yes" and "" to display instead of "No" in the list box (though not in the table)?

Thanks



Remster

[maximus]

A suggestion go to form design view and got to the RowSource of the List Box or Combobox. Create a query with the table from which you want the data to be displayed in the list box.

Now Create a Calculative Field and Suppose My Check Box Field Is MM. I will Create a Calculative Field with the following:

iif([MM]=True,"Current version")

Now adjust the column Count and width to display the Colums.

[Remster]

Bingo! Many thanks.