设置选项单选按钮以输入文本 [英] Setting an option radio button to input text
问题描述
好的，我知道如何根据其他列中的数字使查询/报告/等显示文本值..
（IIF（[Field] ，通过，失败）
但是......这可能妨碍任何查询，我被告知除非绝对必要，否则不应该使用。
我想设置一个单选按钮，将文本值输入表而不是数字。
也许可以用VB完成。 。
我不知道如何实际编写代码，但我猜这个想法有什么关系..
如果表格。 Option108 =" 1"
THEN [Table]。[Fieldname] =" Text"
ELSE [Table]。[Fieldname] =" Fail"
END IF
或者其他东西......
Alright, I understand how to make a query/report/etc display a text value based on what number the other column has in it..
(IIF([Field],"Pass","Fail")
But.. this can be a hamper on any query and I am told should not be used unless absolutely necessary.
I would like to set up a radio button to input a text value into a table instead of a number.
Perhaps it can be done with VB..
I have no idea how to actually write the code, but I''m guessing something having to do with this idea..
IF Form.Option108 = "1"
THEN [Table].[Fieldname]="Text"
ELSE [Table].[Fieldname]="Fail"
END IF
or something...
推荐答案
表格必须绑定到上述表格和字段必须出现在控件中的表格上。
Le ts调用表格frmResults，Option Group optSuccess和字段txtFieldName。然后在选项组的After Update事件中使用select case语句。
The form will have to be bound to the aforementioned table and the field will have to be present on the form in a control.
Lets call the form frmResults, the Option Group optSuccess and the field txtFieldName. Then using a select case statement in the After Update event of the option group.
单选按钮来了在一个Frame中有一些单选按钮。
每个RB都会返回一个True或False的值。
此外，Frame将有一个匹配的值单选按钮当前设置为True。
假设我的框架有三个RB编号为1,2和& 3.
如果选择3：
RB1 = False
RB2 = False
RB3 = True
帧= 3
玛丽，你再次揍我:(
（很好的代码顺便说一句）。
Radio buttons come within a Frame which has a number of Radio buttons in it.
Each RB will return a value of True or False.
Also, the Frame will have a value which matches the Radio button currently set to True.
Say I have a frame with three RBs numbered 1, 2 & 3.
If 3 is selected :
RB1 = False
RB2 = False
RB3 = True
Frame = 3
Mary, You pipped me again :(
(Nice code btw).
玛丽，你再次给我打了个招呼:(
（好的代码顺便说一句）。
Mary, You pipped me again :(
(Nice code btw).
仍未转换，我总是在选项组框架中使用选择案例。它只是有意义。继续尝试。
Mary;）
Still not converted, I always use select case in option group frames. It only make sense. Keep trying.
Mary ;)
这篇关于设置选项单选按钮以输入文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
