Disable Label in a Form

S

Stuart

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.
 
S

Stuart

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.
 
T

Tom Ogilvy

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.
 
S

Stuart

Thanks for that.

Regards.

Tom Ogilvy said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top