Convert Label to Textbox ??

I have around 20 labels on a search screen, now I realize I want the user to be able to click on the label so I need to convert them all to textboxes. Is there a quick way?

Highlight them, right-click and select Change To... and then Text Box.

Rick B

"David" wrote in message
...
I have around 20 labels on a search screen, now I realize I want the user to
be able to click on the label so I need to convert them all to textboxes. Is
there a quick way?

Note: You will have to do them one at a time. If you highlight multiple
labels, the "Change To" option will not be available.

Rick B


"Rick B" wrote in message
...
Highlight them, right-click and select Change To... and then Text Box.

Rick B

"David" wrote in message
...
I have around 20 labels on a search screen, now I realize I want the user to
be able to click on the label so I need to convert them all to textboxes. Is
there a quick way?

Labels have a Click event. If the user just needs to click on the label and
not change the contents, then you can leave them as labels.

--
- - - - - - - - - - - - - - - - -
Ken Snell
MS ACCESS MVP

"David" wrote in message
...
I have around 20 labels on a search screen, now I realize I want the user
to be able to click on the label so I need to convert them all to textboxes.
Is there a quick way?

I dont see any click event for labels in Access 2K, in fact no events at all ???

My experience is with ACCESS 2002, which has Click, Double Click, Mouse
Down, Mouse Move, and Mouse Up events for labels.

So, perhaps you can't do this in ACCESS 2000...sorry.

--

Ken Snell
MS ACCESS MVP

"David" wrote in message
...
I dont see any click event for labels in Access 2K, in fact no events at
all ???

"David" wrote in message
...
I dont see any click event for labels in Access 2K, in fact no events at all
???

They have to be free-standing. If they are attached to a TextBox or other
control then they don't.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

On Wed, 2 Jun 2004 15:19:31 -0500, Rick B wrote:

Highlight them, right-click and select Change To... and then Text Box.

Rick B

"David" wrote in message
...
I have around 20 labels on a search screen, now I realize I want the user to
be able to click on the label so I need to convert them all to textboxes. Is
there a quick way?

It hasn't changed, Ken.

David,
Labels which are added to the form from the tool box have events.

Labels which are included when a bound field is added from the Field
List do not have events, nor do labels included when a new, unbound
text control is added to the form.

Because they are attached to a text control, clicking on the attached
label is the same as setting focus to the text control and therefore
the click event would be useless.

Select one Label at a time.
Right-click and select Change To: Text Control.
Or...
Delete each label and add a new unbound label from the tool box.
These will have events.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

"fredg" wrote in message
...
It hasn't changed, Ken.


Thanks, Fred.
--

Ken Snell
MS ACCESS MVP

I use A2K

In addition, if a standard label is cut and pasted to a
control box, it loses its events (ie becomes a non-
clickable label).

So, if you want to use a lable for events (ie, click
events), avoid attaching to a control box.

Adam


-----Original Message-----
On Wed, 2 Jun 2004 15:19:31 -0500, Rick B wrote:

Highlight them, right-click and select Change To... and
then Text Box.

Rick B

"David" wrote in message
news:E4471B43-94B0-46AF-B8D5-
...
I have around 20 labels on a search screen, now I
realize I want the user to
be able to click on the label so I need to convert them
all to textboxes. Is
there a quick way?

It hasn't changed, Ken.

David,
Labels which are added to the form from the tool box have
events.

Labels which are included when a bound field is added
from the Field
List do not have events, nor do labels included when a
new, unbound
text control is added to the form.

Because they are attached to a text control, clicking on
the attached
label is the same as setting focus to the text control
and therefore
the click event would be useless.

Select one Label at a time.
Right-click and select Change To: Text Control.
Or...
Delete each label and add a new unbound label from the
tool box.
These will have events.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.