Add Text Box without automatically adding the label

  • Thread starter AkAlan via AccessMonster.com
  • Start date
A

AkAlan via AccessMonster.com

I'm using MS Access 2007 and can't figure out how to disable the label from
being added when I add a textbox to a form or report. I used to be able to do
that with older versions, did they remove that option?
 
A

AkAlan via AccessMonster.com

Did you even read my post? I don't want the label to be automatically added
with the text box.
 
A

Arvin Meyer [MVP]

I believe the "sticky" label has been a part of every version of Access. I
just delete the ones I don't want. If I need several without labels, I add
one, delete the label, then duplicate the textbox I just added.
 
L

Linq Adams via AccessMonster.com

I'm not sure about v2007, but in previous versions you would

1) Delete the label from one textbox
2) Select that textbox
3) Click on Format in the menu
4) Click on Set Control Defaults

Now, for that form, textboxes, when added, will not have labels attached
automatically. You can usethis with other formatting, as well. For instance,
if you want all labels to have text that is bold, create a label. Set it's
font to Bold. With the label selected, follow Steps 3 & 4 above.

Note that you have to set the Control Defaults for each form.

I simply have a series of "template" forms that I set up like this,
formatting onjects the wayI like them, in a utility database I maintain. When
I need a pre-formatted form I simply import it into my current app.

Hopefully this method of setting the Control Defaults is still available in
2007.
 
B

BruceM

Your combative response is unlikely to win you a lot of friends here. This
is a volunteer newsgroup. If an answer is not to your liking, or if it
misses your point, please understand that nevertheless somebody volunteered
their time. It would be better to try something like: "OK, but I was hoping
there is a way to avoid automatic labels with text boxes."
In versions of Access before 2007 it was possible to set it up for a
particular database so that the label is not added automatically. The
procedure is to open the toolbox, click the text box icon, click View >>
Properties, and set Auto Label to No in the Default Text Box property sheet
that appears. I don't know if this is possible in Access 2007, but if it is
I expect it is by way of a similar route. I often disassociate text boxes
and their labels, but I need the label more often than not, so I find it
simplest simply to delete unwanted labels.
 
B

BruceM

I see that somebody already responded with a related approach to my previous
suggestion that works for a particular form. To tell you the truth, I'm not
sure if my suggestion works for the whole database or just for a particular
form, but in any case continually resetting the default properties is the
only solution, and it is a partial solution at that.
 
A

AkAlan via AccessMonster.com

So far I cannot find that same functionality in Access 2007. Thanks for all
the post's and my apologies for sounding a bit combative, that was wrong.
 
Top