Results 1 to 5 of 5
  1. #1
    armyofdux is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Posts
    55

    Combo box Header Rows

    I have a combo box row sourcing to a different table with my selections in it. Is there anyway you can bring the header rows with it?

    For example:



    I have class name, class start date, and class end date. Since some of those dates are in close proximity in time to one and other I would like the header rows to be brought with the selections? Is that possible?

  2. #2
    armyofdux is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Posts
    55
    Disregard I found it... so stupid am I.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    For those searching later, presumably you found the Column Heads property of the combo.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Also, since Field names should avoid the use of special characters, with the exception of the Underscore character, they tend to be somewhat odd looking, with, for instance a Field for person's first name being called FirstName or First_Name. If you'd like the Column Header to look a little more 'normal,' you could go into Table Design View, find the Field's Caption Property, and enter First Name, with the Space, and that's how the Column Header will be displayed.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    armyofdux is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Posts
    55
    Quote Originally Posted by pbaldy View Post
    For those searching later, presumably you found the Column Heads property of the combo.
    Yes indeed that is where I found it.

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

Similar Threads

  1. Replies: 9
    Last Post: 11-05-2014, 09:23 AM
  2. Replies: 13
    Last Post: 06-13-2014, 03:25 PM
  3. Replies: 1
    Last Post: 04-06-2014, 10:58 AM
  4. Concatenate 3 rows into single header row
    By kestefon in forum Access
    Replies: 13
    Last Post: 01-31-2014, 06:10 PM
  5. Number of rows in a subform by combo box
    By outhwaik in forum Forms
    Replies: 11
    Last Post: 09-07-2011, 07:42 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