在 Microsoft Access 2007 中创建可扩展表单
我需要从 Microsoft Access 表单中收集一些信息，并且需要将所有内容尽可能组织起来。
有很多栏目可以填写，但不一定适用于所有人，我希望一切都尽可能保持干净。
在表单中，是否有任何方法可以仅在用户说他们有该信息时才显示某些输入框？
例如：
你有狗吗？ () 是 (o) 否
你有狗吗？ (o) 是 () 否............狗的名字：[_________________________]
是/否不应该添加到数据库中，但如果需要的话我可以将它们转储到某个地方。
提前致谢！
贾斯汀
·PS 我也想把这个放在 SharePoint 上，所以如果你能快速帮我完成这个，我会额外加分。 再次感谢！
I need to gather some information from a Microsoft Access form and I need everything to be as organized as possible.
There are a lot of columns that can be filled out, but don't necessarily apply to everyone and I want to keep everything as clean as possible.
In a form, is there any way to have certain input boxes displayed only if the user says they have that information?
For example:
Do you have a dog? () yes (o) no
Do you have a dog? (o) yes () no.............Dog name: [_________________________]
The yes's/no's shouldn't be added to the database, but I can dump them somewhere if need be.
Thanks in advance!
Justian
P.S
I'd like to put this on SharePoint as well, so extra brownie points if you can run me through that as well real quick.
Thanks again!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我通常处理这个问题的方法是在选项组的框架内使用第一个问题的选项组和用于其他信息的禁用文本框。在选项组的 AfterUpdate 事件中，您设置文本框的启用属性：
...假设 YES 选项的值为 1。
您可能希望将选项组的默认值设置为 NO 选项，然后默认情况下会禁用名称字段。
您还需要表单的 OnCurrent 事件来执行与 AfterUpdate 事件中相同的操作。
The way I usually handle this is with an option group for the first question, and a disabled text box for the other information, inside the frame of the option group. In the AfterUpdate event of the option group, you set the enabled property of the textbox:
...assuming that the value of the YES choice is 1.
You'd likely want to set the default value of the option group to the NO choice, and then you'd have the name field disabled by default.
You would also need the OnCurrent event of your form to do the same thing as in the AfterUpdate event.