Results 1 to 3 of 3
  1. #1
    werunthings is offline Novice
    Windows 7 32bit Access 2016
    Join Date
    Mar 2018
    Posts
    1

    having different display controls (eg list, combo list, text) in the same table

    I'd like to create a form with multiple columns and rows. Some of the options will allow the user to input text, other others will permit them to select from a list (one or more response options).

    I've provided a screenshot to help explain.

    I am relatively new to access and aware of a list or combobox (display control) and where i can place a value list in the row source type. However, I can only make single columns.



    Therefore, Id like to add a column that allows me to have text options, another column that shows a list, another column for a combo list, and one for a checkboxes.

    How can I create a column that allows for a checkbox, another column that is a drop down list, and a third that is a combo list in the same table?

    I've attached a screenshot to help explain the type of form I am hoping to create.
    Attached Thumbnails Attached Thumbnails Untitled.png  

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    However, I can only make single columns.
    Why, because you don't know how to make a multi column combo with a value list? Because you're not allowed to?
    If the former, maybe it would entirely change your approach?
    You should elaborate on the purpose and goal as the information is somewhat vague. The image looks a bit fuzzy when I enlarge it, so it's hard to say for sure, but that seems to be a lot of dis-similar information that you're trying to put in one table.

    The short answer to
    How can I create a column that allows for a checkbox, another column that is a drop down list, and a third that is a combo list in the same table?
    is that a field for each control has to exist in the table and be bound to it.

    EDIT: thank you alansidman - wish I had seen that first.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 8
    Last Post: 12-13-2017, 10:38 AM
  2. Replies: 4
    Last Post: 08-22-2015, 12:30 PM
  3. Replies: 3
    Last Post: 03-17-2015, 07:44 AM
  4. Replies: 4
    Last Post: 03-12-2015, 08:24 AM
  5. Combo Box List display HELP!
    By ehabo in forum Access
    Replies: 11
    Last Post: 01-04-2011, 12:55 PM

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