PDA

View Full Version : Is a text box present?



mud2
04-27-2005, 07:23 AM
In my continuing saga...I make a form on the fly, using VBA. The form design has one text box. The record source is an SQL with a variable. If the variable is found, the form opens and fills the text box with the searched for variable. If the variable is not found, the form opens, but the text box isn't opened. I want to test on the contents of the text box, but if no match is found, the text box isn't opened. So, Next work-around is:
Is there a way to (using VBA) determine if the text box has been opened? I'm not interested in the actual contents, just if, or if not a match has been found.

And thanks Killian for your very prompt answer to my previous question. One answer there is to close the form and then to rename it!

OBP
04-27-2005, 10:59 AM
mud2, why do you need to test if the text box is open, you will already know that from whether or not the variable was found.