Disable Label in a Form
 

The label is within a frame in a form. The frame is enabled.
I do not want a user to edit the label, so I have it
disabled.......but this greys out the text in the label
both in the form and on the printout.

Is there a way around this, please?

Regards.

Disable Label in a Form
 

The user can't edit a label anyway. That is the purpose of a label??

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
The label is within a frame in a form. The frame is enabled.
I do not want a user to edit the label, so I have it
disabled.......but this greys out the text in the label
both in the form and on the printout.

Is there a way around this, please?

Regards.

Disable Label in a Form
 

My mistake. I had unsuccessfully tried to create a
multi-line Label (to hold an address). Forgot that I
had changed it to a text box .... it was this textbox
that was greying out.
Am now using a series of labels, where each holds
one line of the address.

Regards and thanks.

"Tom Ogilvy" wrote in message
...
The user can't edit a label anyway. That is the purpose of a label??

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
The label is within a frame in a form. The frame is enabled.
I do not want a user to edit the label, so I have it
disabled.......but this greys out the text in the label
both in the form and on the printout.

Is there a way around this, please?

Regards.

Disable Label in a Form
 

this worked for me with 1 label

Private Sub UserForm_Initialize()
Label1.WordWrap = True
Label1.Caption = "The quick" & Chr(10) & _
"Fox Jumped Over the Lazy Dog's Back and" & _
" Speedily Ran Away"

End Sub

showing a forced return after "quick" and then using workwrap for the rest
although other forced returns could be embedded.

--
Regards,
Tom Ogilvy


"Stuart" wrote in message
...
My mistake. I had unsuccessfully tried to create a
multi-line Label (to hold an address). Forgot that I
had changed it to a text box .... it was this textbox
that was greying out.
Am now using a series of labels, where each holds
one line of the address.

Regards and thanks.

"Tom Ogilvy" wrote in message
...
The user can't edit a label anyway. That is the purpose of a label??

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
The label is within a frame in a form. The frame is enabled.
I do not want a user to edit the label, so I have it
disabled.......but this greys out the text in the label
both in the form and on the printout.

Is there a way around this, please?

Regards.

Disable Label in a Form
 

Thanks for that.

Regards.

"Tom Ogilvy" wrote in message
...
this worked for me with 1 label

Private Sub UserForm_Initialize()
Label1.WordWrap = True
Label1.Caption = "The quick" & Chr(10) & _
"Fox Jumped Over the Lazy Dog's Back and" & _
" Speedily Ran Away"

End Sub

showing a forced return after "quick" and then using workwrap for the rest
although other forced returns could be embedded.

--
Regards,
Tom Ogilvy


"Stuart" wrote in message
...
My mistake. I had unsuccessfully tried to create a
multi-line Label (to hold an address). Forgot that I
had changed it to a text box .... it was this textbox
that was greying out.
Am now using a series of labels, where each holds
one line of the address.

Regards and thanks.

"Tom Ogilvy" wrote in message
...
The user can't edit a label anyway. That is the purpose of a label??

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
The label is within a frame in a form. The frame is enabled.
I do not want a user to edit the label, so I have it
disabled.......but this greys out the text in the label
both in the form and on the printout.

Is there a way around this, please?

Regards.