Loop through 3 textboxes to see which one is visible

[aarondewberry]

All

This is gonna be an easy one for you guys.

Background
I have 3 textboxes: txtPOV, txtPO, txtPU.
Only one of these textboxes will be visible at any one time.

Problem
I want to be able to click a button, then a msgbox will pop up, showing which textbox is visible at that time.

This one has me stumped on a friday!!

 

[HarleyQuinn]

There are loads of ways to do this.

One (rather lazy) way to do this is to set the .Tag property of the textbox to it's name when it's visible (and to "" when it's not), then in your Click event just do

MsgBox txtPOV.Tag & txtPO.Tag & txtPU.Tag

Hope this helps

HarleyQuinn
---------------------------------
Black coat, white shoes, black hat, cadillac. The boy's a timebomb!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before post

 

[TheAceMan1]

How are ya aarondewberry . . .

Perhaps this will do:

[blue]   Dim IsVis As String
   
   If Me!txtPOV.Visible Then IsVis = "txtPOV"
   If Me!txtPO.Visible Then IsVis = "txtPO"
   If Me!txtPU.Visible Then IsVis = "txtPU"
   
   MsgBox "'" & IsVis & "' Is Visible!"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[aarondewberry]

Two different, simple ways.

Thanks guys!

I feel its time to go home already!

 

[SkipVought]

I feel its time to go home already!

It's 5 O'Clock somewhere!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]