Green Triangle upper left corner on design view of a label

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

What does this triangle mean? I know that something isn't set up correctly,
but I need some guidance as to which direction to look.

If you need additional information, just let me know.

Thanks,
 
What does this triangle mean? I know that something isn't set up correctly,
but I need some guidance as to which direction to look.

If you need additional information, just let me know.

Thanks,
Click to expand...

Usually it just means that the label isn't attached to any control (such as a
textbox). It might be some other error.

If you select the control in design view you should see a yellow exclamation
mark icon next to it; select the dropdown on this warning popup and it should
display the nature of the problem.
 
I believe that is exactly what it is... It should be attached to a text box,
however when I clicked on the yellow exclamation mark (thank you) I cannot
seem to change the text number to the one I want.

Basically, I'm asking how do I connect it to the correct text box?
 
Thank you for your assistance, I didn't even notice the yellow exclamation
box before.... Is there a benefit to having the label and text box connected
outside of when you move the text box - the label box moves with it and it
also helps with keeping things organized. This is fine if this is its
purpose, just wondered if there is something else I'm not noticing.

I have always appreciated the assistance I get from this forum...

Thanks!
 
Thank you for your assistance, I didn't even notice the yellow exclamation
box before.... Is there a benefit to having the label and text box connected
outside of when you move the text box - the label box moves with it and it
also helps with keeping things organized. This is fine if this is its
purpose, just wondered if there is something else I'm not noticing.

I have always appreciated the assistance I get from this forum...

Thanks!
Click to expand...

AFIAK the only effect of having the label attached is what you say - dragging.
If the report looks OK with the label where it is, don't worry about it!

If you do want to (re)attach a label, I learned here that you can select the
label; type Ctrl-X to cut it to the clipboard; select the textbox; type Ctrl-V
to paste the label. Access will put it wherever it thinks fit but it will now
be attached to the textbox. You can move it (independently of the textbox) by
grabbing the upper left black "handle" to position it where you wish in
relation to the textbox.
 
Hi Jen,

To join a label to a control, such as a text box, select the label in
question first. Then click on Edit | Cut (or right-click your mouse and
left-click on Cut, or press <Ctrl><X>). Then select the control (text box,
list box, combo box, etc.). Now do the opposite, by clicking on Edit | Paste
(or right-click your mouse and left-click on Paste said:
Is there a benefit to having the label and text box connected
outside of when you move the text box
Click to expand...

Frankly, I think Microsoft was in error to identify a disassociated label as
an "Error". These are nuisance warnings, and nothing more. I suppose one
benefit, on a form, would be that you can implement "hot keys", by including
the ampersand (&) sign in front of the letter in the label's caption that you
want to allow a user to activate by using the <Alt> key plus the letter in
question. That type of functionality would not be expected to work with a
disassociated label.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
Is there a benefit to having the label and text box connected
outside of when you move the text box - the label box moves with
it and it also helps with keeping things organized. This is fine
if this is its purpose, just wondered if there is something else
I'm not noticing.
Click to expand...

For one, an attached label can be referred to through the Controls
collection of the control it's attached to:

Me!txtMyTextBox.Controls(0).Caption = "Some text"

You can then set properties for that label without needing to know
its actual name. Likewise, if you're doing something like this to
set up a form's controls:

Dim ctl As Control

For Each ctl in Me.Controls
Select Case ctl.ControlType
Case acTextBox, acComboBox, acCheckBox, acListBox
If ctl.Controls.Count > 0 And IsNull(ctl) Then
ctl.Controls(0).ForeColor = 255
End If
End Select
Next ctl
Set ctl = Nothing

This would set the labels of all controls without a value to RED.

That's just an example of where attached labels are useful. Also, if
you disable a control with an attached label, the label gets the
"disabled" look, too.

I think that in general, non-attached labels should be the exception
rather than the rule, at least for labels that describe a control.
There are certainly plenty of needs for unattached labels, and in
those cases, it would be nice if after a certain point in a form's
life, you could turn off the error reporting of unattached labels.
But it's a pretty minor annoyance overall.
 
Thank you for the various perspectives and information.

As always, I really appreciate it.

Jen
 
Back
Top