Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to set textbox to NOT visible in VBA 1

Status
Not open for further replies.

amcodah

Programmer
Jul 9, 2003
80
NO
Me!TypeKommentar.Visible = False

Why doesn't this work? Anyone else got any ideas?
Thanks,
/am
 
Just out of curiosity why can't you just assign it directly like:

TypeKommentar.Visible = False

Bill
 
in ure code module type me. this will give u a list of all controls etc within ure forms report etc.

scroll down to find the control ure after. then type . again and this will give u a list of all activities which can be done of that control. Scroll and find visible. then type = false

me.controlname.visible = false
 
Ah, thanks drewduncan!. For some reason my help file showed "Me!controlname.visible = false".

Bill, I think "Me.controlname.visible = false" is faster than "controlname.visible = false", but both methods work yes.

/am
 
Oh well, I discovered that my textbox doesn't have the option of choosing "Visible". Just "Value" which means I probally can't hide it?
 
You might be surprised
type in Me!controlname.visible = false
in the oncurrent event and see what happens

Hope this helps
Hymn
 
I just had to re-add the formfield ;) ah, love thoose bugs.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top