{"id":24763,"date":"2024-03-16T03:48:46","date_gmt":"2024-03-16T03:48:46","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/"},"modified":"2024-03-22T04:32:01","modified_gmt":"2024-03-22T04:32:01","slug":"how-to-set-up-dropdown-list-options-in-access","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/","title":{"rendered":"How to set up dropdown list options in access?"},"content":{"rendered":"

In Access, you can use the form designer to set the options for a dropdown list. Here are the steps to set the dropdown list options.<\/p>\n

    \n
  1. Open Access and open the form that you want to edit.<\/li>\n
  2. Select the field or control to which you want to add a dropdown list in the form designer.<\/li>\n
  3. In the properties window, locate the “Row Source Type” property and set it to “Value List”.<\/li>\n
  4. In the “Row Source” property, enter the options for the dropdown list. Separate each option with a semicolon (;). For example: Option 1; Option 2; Option 3.<\/li>\n
  5. Save the form and execute it. Now, the field or control will display a dropdown list, allowing the user to select an option from it.<\/li>\n<\/ol>\n

    In addition to the methods mentioned above, you can also use queries as the row source for a drop-down list. This allows for more flexibility in retrieving options from a table or query.<\/p>\n

    Below are the steps for using a query as the data source for a drop-down list:<\/p>\n

      \n
    1. Create a query to retrieve options for a dropdown list. The query should return at least two columns, one for the display value and another for the actual return value.<\/li>\n
    2. Select the field or control in the form designer where you want to add a drop-down list.<\/li>\n
    3. In the property window, locate the “Row Source Type” property and set it to “Table\/Query”.<\/li>\n
    4. In the “Row Source” property, enter the name of the query or SQL statement.
      \nFor example: SELECT DisplayValue, ReturnValue FROM OptionsTable<\/li>\n
    5. In the “Bound Column” property, enter the index of the column where the actual value is returned. The indexing starts from 1.
      \nFor example, if the actual value is in the second column returned by the query, set the “Bound Column” to 2.<\/li>\n
    6. In the “Column Count” property, input the number of columns returned by the query. For example, if the query returns two columns, set the “Column Count” to 2.<\/li>\n
    7. In the “Column Widths” property, input the width of each column, separated by a semicolon (;). For example, if a query returns two columns and you want the first column to be 100 pixels wide and the second column to not be displayed (width 0), then set “Column Widths” to 100;0.<\/li>\n
    8. Save the form and execute it. Now, the field or control will display a drop-down list, allowing the user to select an option from it.<\/li>\n<\/ol>\n

      The above are the basic steps for setting up drop-down list options in Access. By utilizing the “Row Source” property and other related properties, you can further customize the appearance and functionality of the drop-down list.<\/p>\n","protected":false},"excerpt":{"rendered":"

      In Access, you can use the form designer to set the options for a dropdown list. Here are the steps to set the dropdown list options. Open Access and open the form that you want to edit. Select the field or control to which you want to add a dropdown list in the form designer. […]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-24763","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nHow to set up dropdown list options in access? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to set up dropdown list options in access?\" \/>\n<meta property=\"og:description\" content=\"In Access, you can use the form designer to set the options for a dropdown list. Here are the steps to set the dropdown list options. Open Access and open the form that you want to edit. Select the field or control to which you want to add a dropdown list in the form designer. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T03:48:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T04:32:01+00:00\" \/>\n<meta name=\"author\" content=\"Liam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Liam\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"How to set up dropdown list options in access?\",\"datePublished\":\"2024-03-16T03:48:46+00:00\",\"dateModified\":\"2024-03-22T04:32:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/\"},\"wordCount\":437,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/\",\"name\":\"How to set up dropdown list options in access? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T03:48:46+00:00\",\"dateModified\":\"2024-03-22T04:32:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to set up dropdown list options in access?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\",\"name\":\"Liam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"caption\":\"Liam\"},\"sameAs\":[\"http:\/\/Wilson\"],\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to set up dropdown list options in access? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/","og_locale":"en_US","og_type":"article","og_title":"How to set up dropdown list options in access?","og_description":"In Access, you can use the form designer to set the options for a dropdown list. Here are the steps to set the dropdown list options. Open Access and open the form that you want to edit. Select the field or control to which you want to add a dropdown list in the form designer. […]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T03:48:46+00:00","article_modified_time":"2024-03-22T04:32:01+00:00","author":"Liam","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Liam","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"How to set up dropdown list options in access?","datePublished":"2024-03-16T03:48:46+00:00","dateModified":"2024-03-22T04:32:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/"},"wordCount":437,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/","name":"How to set up dropdown list options in access? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T03:48:46+00:00","dateModified":"2024-03-22T04:32:01+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-up-dropdown-list-options-in-access\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to set up dropdown list options in access?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671","name":"Liam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","caption":"Liam"},"sameAs":["http:\/\/Wilson"],"url":"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=24763"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24763\/revisions"}],"predecessor-version":[{"id":58818,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24763\/revisions\/58818"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=24763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=24763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=24763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}