Text Box Events Problem (1 Viewer)

[AOSB]

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?

 

[RuralGuy]

How about populating the TextBox in the Current Event of the Form and check the contents there and set the Visibility as well?

 

[vbaInet]

Or if the textbox is transparent and is borderless, just populate the textbox (like RuralGuy said). If there's no data returned it will inadvertently make the textbox "invisible".

 

[AOSB]

Thanks for the quick replies. RuralGuy had the exact answer I was looking for. I thought, wrongly, that the On Current event occurs only when a form is opened. I now know that it also fires whenever the focus leaves one record and moves to another. The clue was in the name of course - On Current refers to the current record changing not the form becoming the current one. Thanks RuralGuy for putting me on the right track.
VbaInet also has made me think that his method might come in very handy one day.

 

[RuralGuy]

That's great! Glad we could help.

 

[PNGBill]

Conditional Formating is another option.