If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Displaying Yes/No as Yes or No instead of -1 and 0
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 |
#3
|
|||
|
|||
Displaying Yes/No as Yes or No instead of -1 and 0
=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! . |
#4
|
|||
|
|||
Displaying Yes/No as Yes or No instead of -1 and 0
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] |
Thread Tools | |
Display Modes | |
|
|