Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Help with grouping on form (97)

    I am very much an Access beginner. I have a large (for me) database that I designed some time ago and have been using since. Occasionally, I need to make a modification and I have to figure out enough of Access to make the modification and then I go back to just using Access for data entry.

    The database is one I use for tracking a large volume of letters. The table has a field for tracking the letter's category. Occasionally, I need to add a new category. That is what this post is about. On the data entry form, I have a bunch of check boxes to pick the category. I have them grouped together so you can only pick one. Pick another and it toggles from the last pick to the one you just picked. I think this is called an option group but I could be wrong about that.

    I know how to add a new check box to the list, that is not a problem. The problem is, I like to a) have the check boxes in alphabetical order and [img]/forums/images/smilies/cool.gif[/img] keep the aligned (currently in a 6x4 grid). It is extremely tedious to move these little boxes around one-at-a-time or even a few-at-a-time to get everything lined up. The right-click and align option is a little help but not too much help with a grid of these.

    I cannot find any easier way but I figure there must be since I cannot imagine a professional spending an hour (like I just did) lining up little boxes. Can anyone help?


    Ronny
    Ronny Richardson

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Help with grouping on form (97)

    Highlight them all and choose Align from the format menu, then use equal distance, then choose Align from the format menu again and choose Left.
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Help with grouping on form (97)

    Ronny,

    In place of checkboxes, you might want to consider a combobox! The problem you are having is that every time you want to add a choice, you need to edit your form; and eventually you will run out of room for your checkboxes. Create a LetterCategory table, which contains fields named CategoryID and CategoryName. Define a one-to-many relationship between this table and your Letter table. On your form, use the Wizard to create a combo box with LetterCategory as the RowSource, it will offer to hide the CategoryID column, so all you see is the CategoryName. Now when you want to add a new Category, you merely add a new record to your LetterCategory table; you no longer need to edit the form.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Help with grouping on form (97)

    My align menu only has left, right, top, bottom, and grid. There is not equal distance option.


    Ronny
    Ronny Richardson

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Help with grouping on form (97)

    Sorry about that, I meant Format / Vertical Spacing / Make Equal.
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  6. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Help with grouping on form (97)

    Pat,

    When I try this, Access automatically greatly expands the box that surrounds the checkboxes and then spreads everything around seemingly randomly. The attached JPG shows a before and after. Any suggestions?

    Ronny
    Attached Images Attached Images
    Ronny Richardson

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Help with grouping on form (97)

    Be careful what you select before you try aligning them. Access sometimes behaves this way, but usually you can get around it by selecting only the control itself, not its label, and aligning the controls. Then you select the labels and align them separately. I have seen situations where You had to copy the Top value from the properties of on control and select the other controls and apply the same top value rather than aligning them.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •