I am using Office 365 Microsoft Access (continuous form)
I have a textbox in the header section situated exactly above the related Access data field.
When that textbox has focus............... When a user presses a key, then I would like to detect this in some way. My code needs to know what that textbox looks like at that moment so that I can do dynamic filtering on the related field.
My question. How do I capture the current state of that textbox when the user has made a change to the textbox whilst still in the "edit mode".
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…