Question on Enable Feature

  • Thread starter Thread starter scott04
  • Start date Start date
S

scott04

Hi everyone, I have a general question involving coding using the enable
feature. Is there any way to have the code not grey out the label on the
form and only the textbox it is supporting? Here is an example:
Private Sub Combo45_AfterUpdate()
Me.Miami.Enabled = Nz(Me.Combo45, False)
When this code is run the Miami label and box are both greyed out. I was
just wondering from a design point of view is it possible to only have the
box greyed and label ignored?
 
Seperate the table from the text box.

Select the lable, cut it (Ctrl + X) and then click on the form (to lose the
focus from a text box) and paste back it back to the form (ctrl + v) that way
the lable will have no connection to the text box
 
scott04 said:
Hi everyone, I have a general question involving coding using the enable
feature. Is there any way to have the code not grey out the label on the
form and only the textbox it is supporting? Here is an example:
Private Sub Combo45_AfterUpdate()
Me.Miami.Enabled = Nz(Me.Combo45, False)
When this code is run the Miami label and box are both greyed out. I was
just wondering from a design point of view is it possible to only have the
box greyed and label ignored?
Click to expand...

Yes, divorce the label from the text box. You can do that by cutting and
pasting, just make sure the text box is *not* selected when you paste.

HTH - Keith.
www.keithwilby.com
 
Back
Top