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

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!

on the Porperty Sheet you can set Format to Yes/No

laura.dodge wrote:
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!

--
spread the WORD

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201001/1

=IIF([youryesnofield]=-1,"Yes","No")
--
Milton Purdy
ACCESS
State of Arkansas


"laura.dodge" wrote:

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

On Thu, 21 Jan 2010 12:03:40 -0800 (PST), "laura.dodge"
wrote:

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

John W. Vinson [MVP]