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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|