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  

Forms & Reports Labels on placing the field



 
 
Thread Tools Display Modes
  #1  
Old April 27th, 2010, 05:48 PM posted to microsoft.public.access.forms
Dwade
external usenet poster
 
Posts: 17
Default Forms & Reports Labels on placing the field

Normally it has been that when I placed a field the label automatically went
as well.

This is no longer happening only the field is being placed. No label. I want
the label to appear and be connected automatically.

I somehow must have changed something but what and how do I get it back to
normal.
  #2  
Old April 27th, 2010, 08:47 PM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Forms & Reports Labels on placing the field

Change the default settings for a text box.
This will apply to the form you are working on.
To change the default settings, click to add new textbox to your form.
Before you place the textbox on the form, go to the properties dialog for
the textbox, format tab and find the property for including a label with the
textbox.
Set it to yes.
Now put the textbox on the form.
This will change the default for all new textboxes you put on this form.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Dwade" wrote in message
...
Normally it has been that when I placed a field the label automatically
went
as well.

This is no longer happening only the field is being placed. No label. I
want
the label to appear and be connected automatically.

I somehow must have changed something but what and how do I get it back to
normal.




  #3  
Old April 27th, 2010, 09:03 PM posted to microsoft.public.access.forms
fredg
external usenet poster
 
Posts: 4,386
Default Forms & Reports Labels on placing the field

On Tue, 27 Apr 2010 09:48:04 -0700, Dwade wrote:

Normally it has been that when I placed a field the label automatically went
as well.

This is no longer happening only the field is being placed. No label. I want
the label to appear and be connected automatically.

I somehow must have changed something but what and how do I get it back to
normal.


Access 2003 or earlier?

From Access Help...

Default + Change default properties for a control type

In a form or report, you can change the default properties for new
controls. This procedure does not apply to data access pages.

Open a form or report in Design view.
Do one of the following:
Change the default settings for a type of control

In the toolbox, click the tool for the type of control that you want
to change. For example, if you want to change the default control
style for text boxes, click the Text Box tool .
Display the property sheet by clicking Properties on the Form Design
or Report Design toolbar.
Microsoft Access changes the title bar of the property sheet to
indicate that you've opened the default property sheet for that type
of control.

In the property sheet, change the property settings.

If you want the new settings to apply to all new controls, make the
current form or report a template.

How?

You can either use an existing form or report as a template, or create
a form or report specifically for use as a template. Changing the
default template does not have any effect on existing forms and
reports.

On the Tools menu, click Options.
Click the Forms/Reports tab.
Type the name of the new template in the Form Template or Report
Template box.
Click OK.
Note To see the name of the template that is currently used for new
forms or reports, click Options on the Tools menu, and then click the
Forms/Reports tab.

Note: In your case it's the "Auto Label" property you wish to set to
Yes.



--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
 




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 02:24 PM.


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