条件字段 [英] conditional fields

问题描述

我的表格基本上就像一项调查。我有一个是/否字段我称之为条件1


如果有人不检查条件1，还有其他几个字段不适用给他们。我怎样才能使这些字段保持锁定/不可见，直到检查condition1为止？理想情况下，这些锁定字段也会被Tab键顺序跳过。


我知道我可以使用条件格式，但这并不能解决我的问题。谢谢！


（我是这个论坛的新手并且访问，如果这个问题已经发布，那很抱歉）

解决方案

我们在这里谈论的字段到底有多少？你想让它们看不见（这可能会使形式看起来不平衡）或者只是变灰了吗？ （进入设计视图，选择一个文本框，转到属性 - 数据并更改已启用为否。运行表单以查看我的意思）


欢迎来到TheScripts！


Linq ; 0）>

灰色会很棒。我可以从禁用它们开始，然后设置一个宏来启用它们如果检查了conditional1吗？


i认为大约有30个左右的字段我想要禁用。

如上所述禁用它们是第3步。接下来要做的是转到yes / no勾选框的onchange部分并输入一些代码以便在选中后启用它们。

展开 | 选择 | Wrap | 行号

I''ve got a form that is basically like a survey. I''ve got a yes/no field that i''ll call "condition1"

if someone does not check condition1, there are several other fields that don''t apply to them. how can i make it so that these fields remain locked / invisible until condition1 is checked? Ideally these locked fields would be skipped over by tab order as well.

I know that I can use conditional formatting, but this doesn''t exactly solve my problem. Thanks!

(I''m new to this forum and to access, so sorry if this question has already been posted)

解决方案

Exactly how many fields are we talking about here? And do you want them invisible (which may make the form look unbalanced) or simply greyed out? (Go into Design View, select a textbox, goto Properties - Data and change Enabled to No. Run the form to see what I mean by this)

Welcome to TheScripts!

Linq ;0)>

greyed out would be great. can i start with them disabled and then set up a macro to enable them if conditional1 is checked?

i think there are about 30 or so fields that i''d like to disable.

Disabling them as discribed above is the frist step. The next thing to do is go to the onchange part of your yes/no tick box and enter some code to enable them once it is selected.

Expand|Select|Wrap|Line Numbers

这篇关于条件字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！