A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Add Text Box without automatically adding the label



 
 
Thread Tools Display Modes
  #1  
Old November 6th, 2008, 11:43 PM posted to microsoft.public.access.forms
AkAlan via AccessMonster.com
external usenet poster
 
Posts: 7
Default Add Text Box without automatically adding the label

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?

--
Message posted via http://www.accessmonster.com

  #2  
Old November 6th, 2008, 11:59 PM posted to microsoft.public.access.forms
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Add Text Box without automatically adding the label

Open in design view, click on the label, press DELETE.
--
KARL DEWEY
Build a little - Test a little


"AkAlan via AccessMonster.com" wrote:

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?

--
Message posted via http://www.accessmonster.com


  #3  
Old November 7th, 2008, 12:02 AM posted to microsoft.public.access.forms
AkAlan via AccessMonster.com
external usenet poster
 
Posts: 7
Default Add Text Box without automatically adding the label

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

KARL DEWEY wrote:
Open in design view, click on the label, press DELETE.
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?


--
Message posted via http://www.accessmonster.com

  #4  
Old November 7th, 2008, 02:13 AM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Add Text Box without automatically adding the label

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"AkAlan via AccessMonster.com" u18147@uwe wrote in message
news:8cce3b19615c5@uwe...
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?

--
Message posted via http://www.accessmonster.com



  #5  
Old November 7th, 2008, 05:45 AM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default Add Text Box without automatically adding the label

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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200811/1

  #6  
Old November 7th, 2008, 01:49 PM posted to microsoft.public.access.forms
BruceM[_2_]
external usenet poster
 
Posts: 1,763
Default Add Text Box without automatically adding the label

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.

"AkAlan via AccessMonster.com" u18147@uwe wrote in message
news:8cce662b90aae@uwe...
Did you even read my post? I don't want the label to be automatically
added
with the text box.

KARL DEWEY wrote:
Open in design view, click on the label, press DELETE.
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?


--
Message posted via http://www.accessmonster.com


  #7  
Old November 7th, 2008, 01:53 PM posted to microsoft.public.access.forms
BruceM[_2_]
external usenet poster
 
Posts: 1,763
Default Add Text Box without automatically adding the label

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.

"AkAlan via AccessMonster.com" u18147@uwe wrote in message
news:8cce662b90aae@uwe...
Did you even read my post? I don't want the label to be automatically
added
with the text box.

KARL DEWEY wrote:
Open in design view, click on the label, press DELETE.
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?


--
Message posted via http://www.accessmonster.com


  #8  
Old November 7th, 2008, 05:16 PM posted to microsoft.public.access.forms
AkAlan via AccessMonster.com
external usenet poster
 
Posts: 7
Default Add Text Box without automatically adding the label

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.

Linq Adams wrote:
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.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200811/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:55 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.