Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-13-2019, 04:03 PM   #1
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 677
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Why doesn't the label stay on your Form

In design view, you click on Label, drag it onto the form and let go.


What are you supposed to do next ? Everything I do results in the label just disappearing. You can't even get to it's properties - or can you?

kirkm is offline   Reply With Quote
Old 07-13-2019, 04:13 PM   #2
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,396
Thanks: 68
Thanked 2,701 Times in 2,586 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Why doesn't the label stay on your Form

you have to type sonething in the caption. you can only delete the caption in the Property otherwise the label will be deleted.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 07-13-2019, 04:34 PM   #3
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 677
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Why doesn't the label stay on your Form

I see. So you have to put something only to remove it later? I found that but thought it was so stupid there must be another way.
Usually I spend an hour or so Googling to figure some of this out but often that drives you crazy looking for something e.g. ( "View") only to find it doesn't have what the instructions say is there.
I hope I can ask you a couple more things. I've dragged a pile of option buttons onto a Form and selected them but can't find Font in the Property sheet. Can I get to it anyhow?

Size-Space and "Equal Vertical". No way does this give them all the same vertical spacing. Is this option for something else?

To separate the label from the button (apart from Control x Control v where you must reposition the label afterwards) can you move them all to the left at once ?

Thanks.

kirkm is offline   Reply With Quote
Old 07-13-2019, 08:33 PM   #4
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,396
Thanks: 68
Thanked 2,701 Times in 2,586 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Why doesn't the label stay on your Form

I only experimented it today and found that its true you cannot adjust the spacing of each radio button.
also the labels are impossible to move to left. what I did was delete all labels and inserted new label to the left. then on each radio button, I associated the labels to them using Label Name property.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following 2 Users Say Thank You to arnelgp For This Useful Post:
MickJav (07-14-2019), Uncle Gizmo (07-13-2019)
Old 07-13-2019, 08:45 PM   #5
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 677
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Why doesn't the label stay on your Form

Goodoo, thanks for getting back to me and confirming there's no better way. Will get there in the end!
kirkm is offline   Reply With Quote
Old 07-13-2019, 08:51 PM   #6
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 932
Thanks: 10
Thanked 189 Times in 179 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Why doesn't the label stay on your Form

Quote:
Size-Space and "Equal Vertical". No way does this give them all the same vertical spacing.
I don't get that, or most of the other seemingly impossible things. I put several on a form and chose to space equally - no problem. Put labels on the left too. As for a font, why would you expect to see font properties for a control that has no text? Am I misunderstanding the problems?
I agree, the label thing catches me off guard still, sometimes. Assuming you need the label, then type anything in it next time and it will stay. You don't need the property sheet to edit a label.
P.S. - you do know that option buttons are not of much use if not embedded in a frame, yes?


Label left and unevenly spaced



Arrange>Size/Space>Equal Vertical
Attached Images
File Type: jpg opts1.jpg (27.4 KB, 96 views)
File Type: jpg opts2.jpg (36.2 KB, 95 views)
__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
Old 07-13-2019, 09:09 PM   #7
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 677
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Why doesn't the label stay on your Form

Your Access may be better/later ? Certainly doesn't work here. How did you paste a pic into your message ?
The font property was for the labels.
I don't have them in a Frame - just on a Form. Did you move the labels to the left of the button manually one by one? I could not select them as everything was kind of all together.

kirkm is offline   Reply With Quote
Old 07-13-2019, 09:39 PM   #8
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,271
Thanks: 527
Thanked 927 Times in 879 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Why doesn't the label stay on your Form

Quote:
Originally Posted by arnelgp View Post
labels are impossible to move to left. what I did was delete all labels and inserted new label to the left. then on each radio button, I associated the labels to them using Label Name property.
That's an excellent tip thank you arnelgp!

Seeing as the associated label property is a relatively new feature of MS Access, I wasn't aware of how handy it could be!


Sent from my Pixel 3a using Tapatalk
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)

Last edited by Uncle Gizmo; 07-13-2019 at 10:12 PM.
Uncle Gizmo is offline   Reply With Quote
The Following User Says Thank You to Uncle Gizmo For This Useful Post:
arnelgp (07-13-2019)
Old 07-13-2019, 11:06 PM   #9
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 677
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Why doesn't the label stay on your Form

Handy? I'm missing something here.
I found selecting each Label (or option button) with Control then allowed one left setting for all. But drawing a rectangle to multi-select was hopeless. Also a Font Property then showed up. But as for Vertical spacing - could not.. Arne says No and Micron yes. Different versions of Access? I'm using 2016.
kirkm is offline   Reply With Quote
Old 07-13-2019, 11:14 PM   #10
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,270
Thanks: 0
Thanked 532 Times in 528 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Why doesn't the label stay on your Form

Quote:
Originally Posted by kirkm View Post
I could not select them as everything was kind of all together.
Sounds like controls are in a grouped layout. This can be frustrating when trying to rearrange things. I never group controls. The form wizard always groups controls. Select all controls then right click > Layout > Remove.

I had no problem dragging radio button associated label to left side.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Old 07-13-2019, 11:39 PM   #11
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,356
Thanks: 112
Thanked 2,843 Times in 2,593 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Why doesn't the label stay on your Form

For what its worth ...
1. If you just type a space into a label caption it will not be deleted.
2. To move a radio button label to the left of the button, drag its right border to the left of the button so you are effectively 'reversing it'. Then adjust its width.
You can do this for all labels in an option group at once

Both work in all versions of Access AFAIK
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 07-14-2019, 12:12 AM   #12
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,082
Thanks: 421
Thanked 751 Times in 729 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: Why doesn't the label stay on your Form

Quote:
Originally Posted by Uncle Gizmo View Post
That's an excellent tip thank you arnelgp!

Seeing as the associated label property is a relatively new feature of MS Access, I wasn't aware of how handy it could be!


Sent from my Pixel 3a using Tapatalk
No wonder I could not find it.
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
Old 07-14-2019, 01:58 AM   #13
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,356
Thanks: 112
Thanked 2,843 Times in 2,593 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Why doesn't the label stay on your Form

Quote:
Originally Posted by Uncle Gizmo View Post
Seeing as the associated label property is a relatively new feature of MS Access, I wasn't aware of how handy it could be!
It was added to Access 365 in June 2017.
However you've always been able to associate unattached labels with a control.
Right click the label (or both label & control together) to see the context menu item.
Personally I find the old method quicker to do as no typing needed
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 07-14-2019, 03:35 AM   #14
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,233
Thanks: 40
Thanked 3,643 Times in 3,513 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Why doesn't the label stay on your Form

other thing to do to associate a label to a control it is to delete the label (ctrl-x), select the control you want to associate it with and the paste (ctrl-v)

To my mind, only benefit of associating a label is a) if you hide the control it hides the associated label and b) the label takes on some of the events of the control such as click, mouse move etc
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 07-14-2019, 06:01 AM   #15
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,356
Thanks: 112
Thanked 2,843 Times in 2,593 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Why doesn't the label stay on your Form

Quote:
Originally Posted by CJ_London View Post
To my mind, only benefit of associating a label is a) if you hide the control it hides the associated label and b) the label takes on some of the events of the control such as click, mouse move etc
Both of those are fairly significant benefits in my opinion

Also, in earlier versions, unassociated labels on a tab control were determined to be one of the causes of screen flicker. The advice at that time was to ensure all labels were associated with a control. Not sure if it still applies
https://www.experts-exchange.com/que...cess-2003.html

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Field Label Caption Change won't stay Monsora83 Forms 8 04-09-2015 11:59 PM
Label as button doesn't finalize textboxes krausr79 Modules & VBA 3 04-24-2014 12:38 PM
Label as button doesn't change focus krausr79 Modules & VBA 2 01-20-2014 10:11 AM
'Label' doesn't print on my report martinbanks Reports 6 12-03-2010 02:33 AM
'Stay On Top' form 123James Forms 1 10-02-2006 02:56 AM




All times are GMT -8. The time now is 06:58 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World