{"id":462,"date":"2014-07-23T15:12:00","date_gmt":"2014-07-23T19:12:00","guid":{"rendered":"http:\/\/debradalgleish.com\/blog\/?p=462"},"modified":"2023-07-02T14:30:38","modified_gmt":"2023-07-02T18:30:38","slug":"hide-date-picker-calendar-in-access-form","status":"publish","type":"post","link":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/","title":{"rendered":"Hide Date Picker Calendar in Access Form"},"content":{"rendered":"<p>I\u2019ve been working on a client\u2019s database, in Microsoft Access, and one of the data entry forms has several fields for dates and times.<\/p>\n<p>There\u2019s a nice Date Picker feature that shows a calendar icon, if you click in a date field text box. Click that icon, and a popup calendar appears, so you can select a date, instead of typing it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"datepicker01\" src=\"http:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker01.png\" alt=\"datepicker01\" width=\"280\" height=\"266\" border=\"0\" \/><\/p>\n<p><!--more--><\/p>\n<p>In the old days (Access 2003 and earlier), we had to program all of that, using a form and the calendar control, so this is much easier.<\/p>\n<h3>Hide Date Picker for Time Field<\/h3>\n<p>Unfortunately, Access can\u2019t tell the difference between a time and a date, so that calendar icon appears for Time fields too. I just ignore it, but my client didn\u2019t want to see that icon in the Time fields.<\/p>\n<p>It seemed like a reasonable request, so I checked the properties, and there is a Date Picker setting that you can change.<\/p>\n<p>Here\u2019s how to turn off the Date Picker for a specific field<\/p>\n<ul>\n<li>In Design View, select the field<\/li>\n<li>Press F4, to show the Properties window (unless it\u2019s already visible)<\/li>\n<li>In the Properties window, click the Format tab<\/li>\n<li>In the Show Date Picker property, click the drop down arrow<\/li>\n<li>Select Never (the default setting is For Dates)<\/li>\n<li>Save the Form, and return to Form View<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"datepicker02\" src=\"http:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker02.png\" alt=\"datepicker02\" width=\"388\" height=\"171\" border=\"0\" \/><\/p>\n<h3>Test the Change<\/h3>\n<p>After changing the Show Date Picker setting, go back to Form View. When you click in the Time field on the form, the calendar icon should not appear.<\/p>\n<p>In the screen shot below, I\u2019ve clicked in the Time In field, and there\u2019s no icon at the right side, so the property change worked. I\u2019ll check all the other time fields, to make sure that they have the same Show Date Picker setting.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"datepicker03\" src=\"http:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker03.png\" alt=\"datepicker03\" width=\"288\" height=\"133\" border=\"0\" \/><\/p>\n<p>Now my client won\u2019t be confused about that field, and whether they should enter the date and time, or just the time.<\/p>\n<p>Maybe the next version of Microsoft Access will have a Clock icon, that we can use for time fields! That would be handy.<\/p>\n<p>___________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I\u2019ve been working on a client\u2019s database, in Microsoft Access, and one of the data entry forms has several fields for dates and times. There\u2019s a nice Date Picker feature that shows a calendar icon, if you click in a date field text box. Click that icon, and a popup calendar appears, so you can &hellip; <a href=\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Hide Date Picker Calendar in Access Form&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":459,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-462","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-office-tips"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Hide Date Picker Calendar in Access Form - Debra D&#039;s Blog<\/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:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hide Date Picker Calendar in Access Form - Debra D&#039;s Blog\" \/>\n<meta property=\"og:description\" content=\"I\u2019ve been working on a client\u2019s database, in Microsoft Access, and one of the data entry forms has several fields for dates and times. There\u2019s a nice Date Picker feature that shows a calendar icon, if you click in a date field text box. Click that icon, and a popup calendar appears, so you can &hellip; Continue reading &quot;Hide Date Picker Calendar in Access Form&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/\" \/>\n<meta property=\"og:site_name\" content=\"Debra D&#039;s Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-23T19:12:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-02T18:30:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker01.png\" \/>\n\t<meta property=\"og:image:width\" content=\"280\" \/>\n\t<meta property=\"og:image:height\" content=\"266\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Debra Dalgleish\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Debra Dalgleish\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/\"},\"author\":{\"name\":\"Debra Dalgleish\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/fc3f038bcaeda478f9c5c06cfe648735\"},\"headline\":\"Hide Date Picker Calendar in Access Form\",\"datePublished\":\"2014-07-23T19:12:00+00:00\",\"dateModified\":\"2023-07-02T18:30:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/\"},\"wordCount\":356,\"commentCount\":3,\"image\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker01.png\",\"articleSection\":[\"Microsoft Office Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/\",\"url\":\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/\",\"name\":\"Hide Date Picker Calendar in Access Form - Debra D&#039;s Blog\",\"isPartOf\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker01.png\",\"datePublished\":\"2014-07-23T19:12:00+00:00\",\"dateModified\":\"2023-07-02T18:30:38+00:00\",\"author\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/fc3f038bcaeda478f9c5c06cfe648735\"},\"breadcrumb\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#primaryimage\",\"url\":\"https:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker01.png\",\"contentUrl\":\"https:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker01.png\",\"width\":280,\"height\":266,\"caption\":\"Access date picker\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/debradalgleish.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hide Date Picker Calendar in Access Form\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/#website\",\"url\":\"https:\/\/debradalgleish.com\/blog\/\",\"name\":\"Debra D&#039;s Blog\",\"description\":\"Behind the Scenes in My Online Business\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/debradalgleish.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/fc3f038bcaeda478f9c5c06cfe648735\",\"name\":\"Debra Dalgleish\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/4ce35cfcf6755fd46a43ba02263b28eeee3c46c5caac91f7ff18f31c817bb943?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4ce35cfcf6755fd46a43ba02263b28eeee3c46c5caac91f7ff18f31c817bb943?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4ce35cfcf6755fd46a43ba02263b28eeee3c46c5caac91f7ff18f31c817bb943?s=96&d=mm&r=g\",\"caption\":\"Debra Dalgleish\"},\"url\":\"https:\/\/debradalgleish.com\/blog\/author\/debra\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hide Date Picker Calendar in Access Form - Debra D&#039;s Blog","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:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/","og_locale":"en_US","og_type":"article","og_title":"Hide Date Picker Calendar in Access Form - Debra D&#039;s Blog","og_description":"I\u2019ve been working on a client\u2019s database, in Microsoft Access, and one of the data entry forms has several fields for dates and times. There\u2019s a nice Date Picker feature that shows a calendar icon, if you click in a date field text box. Click that icon, and a popup calendar appears, so you can &hellip; Continue reading \"Hide Date Picker Calendar in Access Form\"","og_url":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/","og_site_name":"Debra D&#039;s Blog","article_published_time":"2014-07-23T19:12:00+00:00","article_modified_time":"2023-07-02T18:30:38+00:00","og_image":[{"width":280,"height":266,"url":"https:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker01.png","type":"image\/png"}],"author":"Debra Dalgleish","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Debra Dalgleish","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#article","isPartOf":{"@id":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/"},"author":{"name":"Debra Dalgleish","@id":"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/fc3f038bcaeda478f9c5c06cfe648735"},"headline":"Hide Date Picker Calendar in Access Form","datePublished":"2014-07-23T19:12:00+00:00","dateModified":"2023-07-02T18:30:38+00:00","mainEntityOfPage":{"@id":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/"},"wordCount":356,"commentCount":3,"image":{"@id":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#primaryimage"},"thumbnailUrl":"https:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker01.png","articleSection":["Microsoft Office Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/","url":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/","name":"Hide Date Picker Calendar in Access Form - Debra D&#039;s Blog","isPartOf":{"@id":"https:\/\/debradalgleish.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#primaryimage"},"image":{"@id":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#primaryimage"},"thumbnailUrl":"https:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker01.png","datePublished":"2014-07-23T19:12:00+00:00","dateModified":"2023-07-02T18:30:38+00:00","author":{"@id":"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/fc3f038bcaeda478f9c5c06cfe648735"},"breadcrumb":{"@id":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#primaryimage","url":"https:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker01.png","contentUrl":"https:\/\/debradalgleish.com\/blog\/wp-content\/uploads\/2014\/07\/datepicker01.png","width":280,"height":266,"caption":"Access date picker"},{"@type":"BreadcrumbList","@id":"https:\/\/debradalgleish.com\/blog\/2014\/07\/23\/hide-date-picker-calendar-in-access-form\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/debradalgleish.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Hide Date Picker Calendar in Access Form"}]},{"@type":"WebSite","@id":"https:\/\/debradalgleish.com\/blog\/#website","url":"https:\/\/debradalgleish.com\/blog\/","name":"Debra D&#039;s Blog","description":"Behind the Scenes in My Online Business","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/debradalgleish.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/fc3f038bcaeda478f9c5c06cfe648735","name":"Debra Dalgleish","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ce35cfcf6755fd46a43ba02263b28eeee3c46c5caac91f7ff18f31c817bb943?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ce35cfcf6755fd46a43ba02263b28eeee3c46c5caac91f7ff18f31c817bb943?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ce35cfcf6755fd46a43ba02263b28eeee3c46c5caac91f7ff18f31c817bb943?s=96&d=mm&r=g","caption":"Debra Dalgleish"},"url":"https:\/\/debradalgleish.com\/blog\/author\/debra\/"}]}},"_links":{"self":[{"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/posts\/462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/comments?post=462"}],"version-history":[{"count":3,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/posts\/462\/revisions"}],"predecessor-version":[{"id":1725,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/posts\/462\/revisions\/1725"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/media\/459"}],"wp:attachment":[{"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/media?parent=462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/categories?post=462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/tags?post=462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}