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  

Unlink Objects on Form



 
 
Thread Tools Display Modes
  #1  
Old February 15th, 2010, 01:50 AM posted to microsoft.public.access.forms
Ken Hudson
external usenet poster
 
Posts: 82
Default Unlink Objects on Form

Access 2007:
I designed a form. All the objects seem to be linked so that I can not edit
the properties (width, height, etc.) of one without changing the other
objects also.
How do I "break" these links to allow editing of each object independently
in design view?

--
Ken Hudson
  #2  
Old February 15th, 2010, 02:03 AM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Unlink Objects on Form

Go to the Arrange tab and choose Remove.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Ken Hudson" wrote in message
...
Access 2007:
I designed a form. All the objects seem to be linked so that I can not
edit
the properties (width, height, etc.) of one without changing the other
objects also.
How do I "break" these links to allow editing of each object independently
in design view?

--
Ken Hudson



  #3  
Old February 15th, 2010, 03:39 AM posted to microsoft.public.access.forms
Ken Hudson
external usenet poster
 
Posts: 82
Default Unlink Objects on Form

Thanks.

Is there a way to set the default so that forms aren't created with this
relationship?
--
Ken Hudson


"Jeanette Cunningham" wrote:

Go to the Arrange tab and choose Remove.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Ken Hudson" wrote in message
...
Access 2007:
I designed a form. All the objects seem to be linked so that I can not
edit
the properties (width, height, etc.) of one without changing the other
objects also.
How do I "break" these links to allow editing of each object independently
in design view?

--
Ken Hudson



.

  #4  
Old February 15th, 2010, 04:24 AM posted to microsoft.public.access.forms
Jan :\)
external usenet poster
 
Posts: 76
Default Unlink Objects on Form

I would sure like to know that too! That default setting is the pits. Why
the default is locked together like that is a poor design for the average
user, IMHO. Using such a layout should be a user option, not Removing it.

Jan

"Ken Hudson" wrote in message
...
Thanks.

Is there a way to set the default so that forms aren't created with this
relationship?
--
Ken Hudson


"Jeanette Cunningham" wrote:

Go to the Arrange tab and choose Remove.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Ken Hudson" wrote in message
...
Access 2007:
I designed a form. All the objects seem to be linked so that I can not
edit
the properties (width, height, etc.) of one without changing the other
objects also.
How do I "break" these links to allow editing of each object
independently
in design view?

--
Ken Hudson



.


  #5  
Old February 15th, 2010, 04:52 AM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Unlink Objects on Form

When you create your form, before you do anything else, open it in design
view.
Right click on the top-most of the stacked controls and choose Layout |
Remove on the
shortcut menu.
All the controls are free to move individually now.

I can't find any way to set the default so that controls are not linked.

I create a lot of forms by copying and pasting a form already in the
database.
That way I am not bothered by the stacked controls created by the form
wizard.
So it's not an issue for me, but as far as I know, there is not any way to
turn it off if using the form wizard.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



"Jan " wrote in message
...
I would sure like to know that too! That default setting is the pits. Why
the default is locked together like that is a poor design for the average
user, IMHO. Using such a layout should be a user option, not Removing it.

Jan

"Ken Hudson" wrote in message
...
Thanks.

Is there a way to set the default so that forms aren't created with this
relationship?
--
Ken Hudson


"Jeanette Cunningham" wrote:

Go to the Arrange tab and choose Remove.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Ken Hudson" wrote in message
...
Access 2007:
I designed a form. All the objects seem to be linked so that I can not
edit
the properties (width, height, etc.) of one without changing the other
objects also.
How do I "break" these links to allow editing of each object
independently
in design view?

--
Ken Hudson


.





  #6  
Old February 15th, 2010, 08:03 AM posted to microsoft.public.access.forms
Jan :\)
external usenet poster
 
Posts: 76
Default Unlink Objects on Form

Hi Jeanette,
"Jeanette Cunningham" wrote in message
...
When you create your form, before you do anything else, open it in design
view.
Right click on the top-most of the stacked controls and choose Layout |
Remove on the
shortcut menu.
All the controls are free to move individually now.


Yes, that is normally what I have to do in 2007, but, I too, leanred this
the hard way, and it was very confusing and irritating until I learned how
to separate them. Most average users do not know what to do with this new
'feature' or how to correct it. The terminology used for the layout
functions is also confusing, making it difficult for average users to even
try to look up how to separate them in the Help files.

I can't find any way to set the default so that controls are not linked.


I have tried to find a way to do that since I found out how to separate
them, but, like you, to no avail.

I create a lot of forms by copying and pasting a form already in the
database.
That way I am not bothered by the stacked controls created by the form
wizard.
So it's not an issue for me, but as far as I know, there is not any way to
turn it off if using the form wizard.


I also use copy/paste a good many forms, as it just saves time and they are
easily revised. I have some forms that I use as templates for other
databases with similar layout needs.

Thank you for the additional input.

Jan

btw...I have a very good friend who lives in Bendigo, not too far from
Melbourne I believe. :-)




Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



"Jan " wrote in message
...
I would sure like to know that too! That default setting is the pits. Why
the default is locked together like that is a poor design for the average
user, IMHO. Using such a layout should be a user option, not Removing it.

Jan

"Ken Hudson" wrote in message
...
Thanks.

Is there a way to set the default so that forms aren't created with this
relationship?
--
Ken Hudson


"Jeanette Cunningham" wrote:

Go to the Arrange tab and choose Remove.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Ken Hudson" wrote in message
...
Access 2007:
I designed a form. All the objects seem to be linked so that I can
not
edit
the properties (width, height, etc.) of one without changing the
other
objects also.
How do I "break" these links to allow editing of each object
independently
in design view?

--
Ken Hudson


.






 




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 07:31 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.