为表单创建重置/清除按钮 [英] Creating a reset/clear button for a form

问题描述

下午好，


我一直在努力解决这个问题。我在Access 2007中有一个未绑定文本框未绑定的搜索表单。提交按钮效果很好，但我尝试创建一个清除按钮，以便用户可以立即清除其信息而不是每个单独的字段。我的表单名称是SearchingForm，文本框是clientname，operatingstate，product。我尝试了以下代码：

Good Afternoon,

I have been trying to figure this out for days. I have a search form in Access 2007 that is unbound with unbound text boxes. The submit button works great, but I am trying to creat a clear button so that the user can clear out their information at once instead of each individual field. My form name is SearchingForm and the text boxes are clientname, operatingstate, product. I have tried the following codes:

展开 | 选择 | Wrap | 行号

推荐答案

刷新不是需要。第二块代码会发生什么？您是收到错误消息还是运行而只是不清除字段？

The refresh isn''t needed. What happens with your second block of code? Do you get an error message or does it run and just not clear the fields?

感谢您的快速回复。在我试过的任何代码块上都没有做任何事情，只是坐在那里。我也试过= Null而不是=""。只是为了澄清我列出的代码不在同一时间，那是我试图让它工作的两次尝试的代码

Thank you for the quick response. On either block of code that I try it does nothing, just sits there. I have also tried the = Null instead of the = "". Just to clarify on the code that I listed it was not in there at the same time, that is code that I tried on two different attempts at trying to get it to work

所以，你的文本框命名为：clientname，operatingstate和product？

So, your textboxes are named: clientname, operatingstate, and product?

这篇关于为表单创建重置/清除按钮的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！