PC Review


Reply
Thread Tools Rate Thread

Anchored fields?

 
 
=?Utf-8?B?RnJlZCBMZUZldnJl?=
Guest
Posts: n/a
 
      7th Sep 2006
When forms are auto-created by table they appear to be anchored within a
column. Is there any easy way to turn this off without having to go field by
field?

Thanks
--
Fred LeFevre
 
Reply With Quote
 
 
 
 
Rick Brandt
Guest
Posts: n/a
 
      7th Sep 2006
Fred LeFevre wrote:
> When forms are auto-created by table they appear to be anchored
> within a column. Is there any easy way to turn this off without
> having to go field by field?
>
> Thanks


I assume you are selecting a table in the db window and then pressing the
Auto-Form button in the toolbar. That will create a form with all of the
controls stacked vertically (if that's what you mean by a column). Just switch
to design view and move them wherever you want. They can be moved in groups.

How would you want them arranged by the wizard otherwise? If you go through the
full-blown wizard rather than using the Auto-Form option you do get a few other
layout options, but you will almost never get a form produced by the wizard that
won't need tweaking afterwards.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


 
Reply With Quote
 
=?Utf-8?B?RnJlZCBMZUZldnJl?=
Guest
Posts: n/a
 
      8th Sep 2006
Thanks however the behaviour remains odd. When I try to move a single field
the operation is on the entire stack. If I select just the field then I am
unable to move it and when I try to resize it the entire stack resizes?

Thanks
--
Fred LeFevre


"Rick Brandt" wrote:

> Fred LeFevre wrote:
> > When forms are auto-created by table they appear to be anchored
> > within a column. Is there any easy way to turn this off without
> > having to go field by field?
> >
> > Thanks

>
> I assume you are selecting a table in the db window and then pressing the
> Auto-Form button in the toolbar. That will create a form with all of the
> controls stacked vertically (if that's what you mean by a column). Just switch
> to design view and move them wherever you want. They can be moved in groups.
>
> How would you want them arranged by the wizard otherwise? If you go through the
> full-blown wizard rather than using the Auto-Form option you do get a few other
> layout options, but you will almost never get a form produced by the wizard that
> won't need tweaking afterwards.
>
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>

 
Reply With Quote
 
Brendan Reynolds
Guest
Posts: n/a
 
      8th Sep 2006
Which version of Access?

--
Brendan Reynolds
Access MVP

"Fred LeFevre" <(E-Mail Removed).(donotspam).> wrote in message
news:205BC9D3-CD7F-44BF-8487-(E-Mail Removed)...
> Thanks however the behaviour remains odd. When I try to move a single
> field
> the operation is on the entire stack. If I select just the field then I
> am
> unable to move it and when I try to resize it the entire stack resizes?
>
> Thanks
> --
> Fred LeFevre
>
>
> "Rick Brandt" wrote:
>
>> Fred LeFevre wrote:
>> > When forms are auto-created by table they appear to be anchored
>> > within a column. Is there any easy way to turn this off without
>> > having to go field by field?
>> >
>> > Thanks

>>
>> I assume you are selecting a table in the db window and then pressing the
>> Auto-Form button in the toolbar. That will create a form with all of the
>> controls stacked vertically (if that's what you mean by a column). Just
>> switch
>> to design view and move them wherever you want. They can be moved in
>> groups.
>>
>> How would you want them arranged by the wizard otherwise? If you go
>> through the
>> full-blown wizard rather than using the Auto-Form option you do get a few
>> other
>> layout options, but you will almost never get a form produced by the
>> wizard that
>> won't need tweaking afterwards.
>>
>>
>> --
>> Rick Brandt, Microsoft Access MVP
>> Email (as appropriate) to...
>> RBrandt at Hunter dot com
>>
>>
>>



 
Reply With Quote
 
=?Utf-8?B?RnJlZCBMZUZldnJl?=
Guest
Posts: n/a
 
      8th Sep 2006
2007
--
Fred LeFevre


"Brendan Reynolds" wrote:

> Which version of Access?
>
> --
> Brendan Reynolds
> Access MVP
>
> "Fred LeFevre" <(E-Mail Removed).(donotspam).> wrote in message
> news:205BC9D3-CD7F-44BF-8487-(E-Mail Removed)...
> > Thanks however the behaviour remains odd. When I try to move a single
> > field
> > the operation is on the entire stack. If I select just the field then I
> > am
> > unable to move it and when I try to resize it the entire stack resizes?
> >
> > Thanks
> > --
> > Fred LeFevre
> >
> >
> > "Rick Brandt" wrote:
> >
> >> Fred LeFevre wrote:
> >> > When forms are auto-created by table they appear to be anchored
> >> > within a column. Is there any easy way to turn this off without
> >> > having to go field by field?
> >> >
> >> > Thanks
> >>
> >> I assume you are selecting a table in the db window and then pressing the
> >> Auto-Form button in the toolbar. That will create a form with all of the
> >> controls stacked vertically (if that's what you mean by a column). Just
> >> switch
> >> to design view and move them wherever you want. They can be moved in
> >> groups.
> >>
> >> How would you want them arranged by the wizard otherwise? If you go
> >> through the
> >> full-blown wizard rather than using the Auto-Form option you do get a few
> >> other
> >> layout options, but you will almost never get a form produced by the
> >> wizard that
> >> won't need tweaking afterwards.
> >>
> >>
> >> --
> >> Rick Brandt, Microsoft Access MVP
> >> Email (as appropriate) to...
> >> RBrandt at Hunter dot com
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
Brendan Reynolds
Guest
Posts: n/a
 
      8th Sep 2006
Form design has changed a lot in Access 2007. I'm not familiar enough with
it to advise you myself, but now that we've established that it is Access
2007 that you are using, perhaps someone who is more familiar with it may be
able to advise you.

--
Brendan Reynolds
Access MVP

"Fred LeFevre" <(E-Mail Removed).(donotspam).> wrote in message
news:A36D3B3D-9EE3-4539-9FE8-(E-Mail Removed)...
> 2007
> --
> Fred LeFevre
>
>
> "Brendan Reynolds" wrote:
>
>> Which version of Access?
>>
>> --
>> Brendan Reynolds
>> Access MVP
>>
>> "Fred LeFevre" <(E-Mail Removed).(donotspam).> wrote in message
>> news:205BC9D3-CD7F-44BF-8487-(E-Mail Removed)...
>> > Thanks however the behaviour remains odd. When I try to move a single
>> > field
>> > the operation is on the entire stack. If I select just the field then
>> > I
>> > am
>> > unable to move it and when I try to resize it the entire stack resizes?
>> >
>> > Thanks
>> > --
>> > Fred LeFevre
>> >
>> >
>> > "Rick Brandt" wrote:
>> >
>> >> Fred LeFevre wrote:
>> >> > When forms are auto-created by table they appear to be anchored
>> >> > within a column. Is there any easy way to turn this off without
>> >> > having to go field by field?
>> >> >
>> >> > Thanks
>> >>
>> >> I assume you are selecting a table in the db window and then pressing
>> >> the
>> >> Auto-Form button in the toolbar. That will create a form with all of
>> >> the
>> >> controls stacked vertically (if that's what you mean by a column).
>> >> Just
>> >> switch
>> >> to design view and move them wherever you want. They can be moved in
>> >> groups.
>> >>
>> >> How would you want them arranged by the wizard otherwise? If you go
>> >> through the
>> >> full-blown wizard rather than using the Auto-Form option you do get a
>> >> few
>> >> other
>> >> layout options, but you will almost never get a form produced by the
>> >> wizard that
>> >> won't need tweaking afterwards.
>> >>
>> >>
>> >> --
>> >> Rick Brandt, Microsoft Access MVP
>> >> Email (as appropriate) to...
>> >> RBrandt at Hunter dot com
>> >>
>> >>
>> >>

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to keep the top of the form anchored at the top forest8 Microsoft Access Forms 1 1st Mar 2010 04:05 PM
how do I release an anchored cell? =?Utf-8?B?RGFycmVsbEdTRg==?= Microsoft Excel Misc 5 2nd Oct 2007 10:01 PM
ListView in MDI Anchored right Jon Vaughan Microsoft VB .NET 0 16th Jun 2006 08:41 AM
Converting anchored from unanchored? =?Utf-8?B?VHJlZXN5?= Microsoft Excel Misc 2 9th Nov 2004 11:28 PM
Re: ANCHORED TITLES J.E. McGimpsey Microsoft Excel Worksheet Functions 0 29th Aug 2003 06:59 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:31 AM.