Hello, I have a form bound (data entry) to a table; there is a text box on the form which is NOT bound to that table. It is bound to a Dlookup on another table. It all works fine. Here is the BUT.
I would like the textbox.visible property to be True ONLY if there is any text in it.
I cannot find which event to put the VBA code in to achieve this.
I could do it easily if I was typing into the box but none of the Events seem to fire when the Dlookup populates it.
Any ideas please?
I would like the textbox.visible property to be True ONLY if there is any text in it.
I cannot find which event to put the VBA code in to achieve this.
I could do it easily if I was typing into the box but none of the Events seem to fire when the Dlookup populates it.
Any ideas please?