有没有办法通过VBA显示控制提示？ [英] Is there a way to make a control tip show up via VBA?

问题描述

我希望能够在 Me.Recordset.NoMatch 为真时显示控件提示。我已经有了进行测试的代码，但是我无法在网上找到如何使其可见。这纯粹是一种美学的东西，所以如果不可能那就没什么大不了的。我刚看到它在其他程序上完成，并认为我会尝试复制它。

I would like to be able to make a control tip show up when Me.Recordset.NoMatch is true. I have the code that does the testing already, but I haven''t been able to find online how to makes it visible. This is purely an aesthetic thing so it is no big deal if it isn''t possible. I''ve just seen it done on other programs and thought I would try to duplicate it.

推荐答案

这是由鼠标Seth管理的。如果有一种方法可以通过代码显式设置它，我非常怀疑它是否可行。

This is managed by the mouse Seth. I very much doubt it could work at all if there were a way to set it explicitly via code.

这可能是复杂的方法，但是如何在我的代码中调用MouseMove事件呢？我可以在之间来回切换文本。和不正确的贷款号码因此当被函数调用时，它将读取不正确的贷款号。并且当由鼠标触发时，它将是。我必须让函数将其设置为不正确的贷款号码，显示它，然后在代码的末尾将其设置回"。这是一个疯狂的人的想法还是值得一试？我还没玩过MouseMove事件，所以我不知道它做了什么，我想在我深入研究它之前我会先运行它。

This might be way to complex, but what about calling the MouseMove event in my code? I could change the text back and forth between "" and "Incorrect Loan Number" so that when called by the function it would read "Incorrect Loan Number" and when triggered by the mouse it would be "". I would have to have the function set it to "Incorrect Loan Number", show it, and then at the end of the code set it back to "". Is this the idea of a crazy person or is it worth a try? I haven''t ever played with the MouseMove event so I''m not sure what all it does and I thought I would run it by you before I dive into it.

它只是突然来找我。我可以在我的If / Then语句中添加一条带有我的消息并使其可见的标签，并使其变得更容易。

It just suddenly came to me. I can just put a label that has my message and make it visible or not in my If/Then statement and make it a whole bunch easier.

这篇关于有没有办法通过VBA显示控制提示？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！