Displaying Yes/No as Yes or No instead of -1 and 0

[laura.dodge]

Hi, I know that I've done this before, but now I can't remember how I
did it...

In my form, I want my Yes/No combo box to display Yes or No instead of
-1 or 0 after the choice is made. I'm remembering something about
column widths, but so far no luck.

Thanks for your help!

 

[NuBie via AccessMonster.com]

Hi, I know that I've done this before, but now I can't remember how I
did it...

In my form, I want my Yes/No combo box to display Yes or No instead of
-1 or 0 after the choice is made. I'm remembering something about
column widths, but so far no luck.

Thanks for your help!

 

[golfinray]

=IIF([youryesnofield]=-1,"Yes","No")

 

[John W. Vinson]

In my form, I want my Yes/No combo box to display Yes or No instead of
-1 or 0 after the choice is made. I'm remembering something about
column widths, but so far no luck.

One way is to change its RowSource to

"Yes";-1;"No";0

RowsourceType should be "Value List", ColumnCounts should be 2, BoundColumn
should be 2, and ColumnWidths something like 0.25";0" (the second value will
be the width of the numeric value, and should be 0 to conceal it).