Can I change a Label in a form on the fly?

[darnnews]

When a user selects a "Medium" in a form I have made, I would like to
change a Label on the form.

Can I change a label based on an update of a listbox?

This code does not work:

Case "Print"
Me.Description = "The print article "
Me.Measurement_Label = "Square Inches"
Case "Radio"
Me.Description = "The radio program "
Me.Measurement_Label = "Seconds"

The Description Text Box updates just fine, but not the label...

What am I missing?

Thanks,
Andrew

[Linda Burnside]

"darnnews" <an************@gmail.comwrote in message
news:11**********************@v61g2000cwv.googlegr oups.com...

When a user selects a "Medium" in a form I have made, I would like to
change a Label on the form.

Can I change a label based on an update of a listbox?

This code does not work:

Case "Print"
Me.Description = "The print article "
Me.Measurement_Label = "Square Inches"
Case "Radio"
Me.Description = "The radio program "
Me.Measurement_Label = "Seconds"

The Description Text Box updates just fine, but not the label...

What am I missing?

Thanks,
Andrew

[Linda Burnside]

You could change the label to a text box if it won't let you update a label.

Linda

"darnnews" <an************@gmail.comwrote in message
news:11**********************@v61g2000cwv.googlegr oups.com...

When a user selects a "Medium" in a form I have made, I would like to
change a Label on the form.

Can I change a label based on an update of a listbox?

This code does not work:

Case "Print"
Me.Description = "The print article "
Me.Measurement_Label = "Square Inches"
Case "Radio"
Me.Description = "The radio program "
Me.Measurement_Label = "Seconds"

The Description Text Box updates just fine, but not the label...

What am I missing?

Thanks,
Andrew

[Bob Quintal]

"darnnews" <an************@gmail.comwrote in
news:11**********************@v61g2000cwv.googlegr oups.com:

When a user selects a "Medium" in a form I have made, I would
like to change a Label on the form.

Can I change a label based on an update of a listbox?

Yes

This code does not work:

Case "Print"
Me.Description = "The print article "
Me.Measurement_Label = "Square Inches"
Case "Radio"
Me.Description = "The radio program "
Me.Measurement_Label = "Seconds"

The Description Text Box updates just fine, but not the
label...

What am I missing?

The property in a label that needs changing is the .Caption
property. unlike the .Value property of a textbox, it is not
default and MUST be specified.
Me.Measurement_Label.caption = "Square Inches" will work

>
Thanks,
Andrew

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[tina]

the default property of a textbox control in a form is Value, so when your
code reads

Me.Description = "The print article "

the actual code that's executed is

Me.Description.Value = "The print article "

a label control does not have a default property. to change the Caption
property of a label, you need to declare it explicitly in the code, as

Me.Measurement_Label.Caption = "Seconds"

hth
"darnnews" <an************@gmail.comwrote in message
news:11**********************@v61g2000cwv.googlegr oups.com...

When a user selects a "Medium" in a form I have made, I would like to
change a Label on the form.

Can I change a label based on an update of a listbox?

This code does not work:

Case "Print"
Me.Description = "The print article "
Me.Measurement_Label = "Square Inches"
Case "Radio"
Me.Description = "The radio program "
Me.Measurement_Label = "Seconds"

The Description Text Box updates just fine, but not the label...

What am I missing?

Thanks,
Andrew