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

  • Thread starter Thread starter laura.dodge
  • Start date Start date
L

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!
 
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.
Click to expand...

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).
 
Back
Top