Question on Enable Feature

[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?

 

[Ofer Cohen]

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

 

[Keith Wilby]

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?

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

 

[scott04]

Thanks