Results 1 to 8 of 8
  1. #1
    pledbetter is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2010
    Location
    Martinsville, IN
    Posts
    31

    Evenly distributing fields

    Besides the ability to align fields in forms and reports, older versions of Access had the ability to evenly distribute fields within a block of selected fields. I cannot find that feature with Access 2007. Does anyone know how to do this is 2007?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

  3. #3
    pledbetter is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2010
    Location
    Martinsville, IN
    Posts
    31

    I already know about de-linking labels from fields

    Rural Guy,
    Thanks for your reply. What I have is a group of fields that are vertically separated by a different number of pixels. There used to be a feature in Access 2003 where you selected a group and clicked (I think it was) "Shape-Distribute" and all the fields would redistribute evenly between the two endpoint fields of the group. I can't find that functionality in 2007.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It is there! Look under the Arrange menu Size/Space.

  5. #5
    pledbetter is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2010
    Location
    Martinsville, IN
    Posts
    31

    Must not be holding my mouth right

    Sorry, I can't find it. I even did a search on that string and it came up with nothing. I even registered and looked again and still nothing. Can you tell me the path to it?

    Thanks

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I assume Access 2007. Here's ac2010 but it is the same. It is right in the middle of the DropDown.

  7. #7
    pledbetter is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2010
    Location
    Martinsville, IN
    Posts
    31
    Leave it to Microsoft to keep rearranging and renaming things so we have to waste time finding them or waste money for training to find where they hid preexisting functionality. I found it. Thanks, Rural Guy.

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad I could help. Thanks for marking the thread as Solved.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Distribute table contents evenly
    By arfaha in forum Access
    Replies: 0
    Last Post: 11-14-2009, 02:32 PM
  2. Replies: 3
    Last Post: 08-10-2009, 08:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums