HOW TO : Show NULLs in Table View - Microsoft: Access Tables and Relationships

<!DOCTYPE html> <html id="XF" lang="en-US" dir="LTR" data-app="public" data-template="thread_view_type_question" data-container-key="node-700" data-content-key="thread-1786807" data-logged-in="false" data-cookie-prefix="xf_" data-csrf="1732703774,f84313c26c795512a068fea778443cf2" class="has-no-js template-thread_view_type_question XenBase layout-classic style-light sidebar-right xb-toggle-default xb-sidebar-show" > <head> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=Edge" /> <meta name="viewport" content="width=device-width, initial-scale=1, viewport-fit=cover">  <script> var dimensionValue1 = 'Programmers'; var dimensionValue2 = 'DBMS Packages'; var dimensionValue3 = 'Microsoft: Access Tables and Relationships'; window.dataLayer = window.dataLayer || []; window.dataLayer.push({ 'Area' : dimensionValue1, 'Category' : dimensionValue2, 'Forum' : dimensionValue3 }); </script>   <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-MMC9PJ9');</script>   <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-TZQ8TVZR');</script>   <script type="text/javascript"> adroll_adv_id = "KCG7QJRNGNEX3GEZSJPEFG"; adroll_pix_id = "HNHCAFVMNNC7FBZP3GMMLE"; adroll_version = "2.0"; (function(w, d, e, o, a) { w.__adroll_loaded = true; w.adroll = w.adroll || []; w.adroll.f = [ 'setProperties', 'identify', 'track', 'identify_email' ]; var roundtripUrl = "https://s.adroll.com/j/" + adroll_adv_id + "/roundtrip.js"; for (a = 0; a < w.adroll.f.length; a++) { w.adroll[w.adroll.f[a]] = w.adroll[w.adroll.f[a]] || (function(n) { return function() { w.adroll.push([ n, arguments ]) } })(w.adroll.f[a]) } e = d.createElement('script'); o = d.getElementsByTagName('script')[0]; e.async = 1; e.src = roundtripUrl; o.parentNode.insertBefore(e, o); })(window, document); adroll.track("pageView"); </script> <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4401622383960692" crossorigin="anonymous"></script>   <script async src="https://securepubads.g.doubleclick.net/tag/js/gpt.js"></script> <script> window.googletag = window.googletag || {cmd: []}; googletag.cmd.push(function() { var pathParts = window.location.pathname.substr(1).split('/'); var mapLeaderboard = googletag.sizeMapping() .addSize([1024, 200], [728, 90]) .addSize([0, 0], [300, 250]) .build(); var mapWallpaper = googletag.sizeMapping() .addSize([1024, 200], [1, 1]) .addSize([0, 0], [[1, 1]]) .build(); var gptSlots = []; googletag.defineSlot('/5272491/dw_network/tektips_customsearchbox', [300, 90], 'div-gpt-tektips_customsearchbox').addService(googletag.pubads()); gptSlots[1] = googletag.defineSlot('/5272491/dw_network/tektips_thread1', [728, 90], 'div-gpt-tektips_thread1').defineSizeMapping(mapLeaderboard).addService(googletag.pubads()); gptSlots[2] = googletag.defineSlot('/5272491/dw_network/tektips_thread2', [728, 90], 'div-gpt-tektips_thread2').defineSizeMapping(mapLeaderboard).addService(googletag.pubads()); googletag.defineSlot('/5272491/dw_network/tektips_thread3', [[728, 90]], 'div-gpt-tektips_thread3').addService(googletag.pubads()); gptSlots[3] = googletag.defineSlot('/5272491/dw_network/tektips_wallpaper', [1, 1], 'div-gpt-tektips_wallpaper').defineSizeMapping(mapWallpaper).addService(googletag.pubads()); googletag.defineSlot('/5272491/dw_network/tektips_sidebar1', [[300, 250], [300, 600]], 'div-gpt-tektips_sidebar1').addService(googletag.pubads()); googletag.defineSlot('/5272491/dw_network/tektips_sidebarbottom', [[300, 250], [300, 600]], 'div-gpt-tektips_sidebarbottom').addService(googletag.pubads()); googletag.pubads().enableSingleRequest(); googletag.pubads().collapseEmptyDivs(); googletag.pubads().setTargeting('articletitle', pathParts[0] ? pathParts[0] : 'home-page'); googletag.enableServices(); }); </script>  <title>HOW TO : Show NULLs in Table View - Microsoft: Access Tables and Relationships | Tek-Tips</title> <link rel="manifest" href="/webmanifest.php"> <meta name="theme-color" content="#647ec4" /> <meta name="apple-mobile-web-app-title" content="Tek-Tips Information Technology Professional Forums"> <meta name="description" content="I know SQL_Server does it. Is there an MS_Access option that'll show NULL fields as something other than blank? Zero-Length would look like " "..." /> <meta property="og:description" content="I know SQL_Server does it. Is there an MS_Access option that'll show NULL fields as something other than blank? Zero-Length would look like " " Space would look like " " NULL would look something like "". I have a DB with poor NULL handling and it would be a huge research help..." /> <meta property="twitter:description" content="I know SQL_Server does it. Is there an MS_Access option that'll show NULL fields as something other than blank? Zero-Length would look like " " Space would look like " " NULL..." /> <meta property="og:url" content="https://www.tek-tips.com/threads/how-to-show-nulls-in-table-view.1786807/" /> <link rel="canonical" href="https://www.tek-tips.com/threads/how-to-show-nulls-in-table-view.1786807/" /> <meta property="og:site_name" content="Tek-Tips" /> <meta property="og:type" content="website" /> <meta property="og:title" content="HOW TO : Show NULLs in Table View - Microsoft: Access Tables and Relationships" /> <meta property="twitter:title" content="HOW TO : Show NULLs in Table View - Microsoft: Access Tables and..." /> <link rel="preconnect" href="https://fonts.googleapis.com"><link rel="preconnect" href="https://fonts.gstatic.com" crossorigin><link href="https://fonts.googleapis.com/css2?family=Poppins:wght@400;700&display=swap" rel="stylesheet"> <link rel="preload" href="/styles/fonts/fa/fa-light-300.woff2?_v=5.15.3" as="font" type="font/woff2" crossorigin="anonymous" /> <link rel="preload" href="/styles/fonts/fa/fa-solid-900.woff2?_v=5.15.3" as="font" type="font/woff2" crossorigin="anonymous" /> <link rel="preload" href="/styles/fonts/fa/fa-brands-400.woff2?_v=5.15.3" as="font" type="font/woff2" crossorigin="anonymous" /> <link rel="stylesheet" href="/css.php?css=public%3Anormalize.css%2Cpublic%3Afa.css%2Cpublic%3Acore.less%2Cpublic%3Aapp.less&s=3&l=1&d=1731063743&k=0e1337d98c8845c72b8d3c46d22feb00bc113906" /> <link rel="stylesheet" href="/css.php?css=public%3Amessage.less%2Cpublic%3Anotices.less%2Cpublic%3Ashare_controls.less%2Cpublic%3Asnog_groups.less%2Cpublic%3Astructured_list.less%2Cpublic%3AsvESE_autocomplete.less%2Cpublic%3Axb.less%2Cpublic%3Axb_search.less%2Cpublic%3Axb_sidebar_login.less%2Cpublic%3Axb_welcome.less%2Cpublic%3Axc_soft_attachment.less%2Cpublic%3Axc_votes_button.less%2Cpublic%3Aextra.less&s=3&l=1&d=1731063743&k=d475410cac2c3d547917cd175bdc60a67bdface3" /> <script src="/js/xf/preamble.min.js?_v=e65b7ca0"></script> </head> <body data-template="thread_view_type_question">  <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-MMC9PJ9" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>   <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-TZQ8TVZR" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  <div class="p-pageWrapper" id="top"> <div class="p-pageWrapper--helper"></div> <div class="xb-page-wrapper xb-canvas-menuActive"> <div class="xb-page-wrapper--helper"></div> <header class="p-header" id="header"> <div class="p-header-inner"> <div class="p-header-content"> <div class="p-header-logo p-header-logo--image"> <a href="https://www.tek-tips.com"> <img src="/styles/nova/tek-tips/header-logo.png" srcset="" alt="Tek-Tips" width="" height="" /> </a> </div> <div class="xb-searchWrapper" id="xb-searchWrapper" tabindex="0"> <form action="/search/search" id="xbSearch" data-xf-init="quick-search" data-autocomplete-filter="null" data-autocomplete-filter="null" class="xb-search" method="post" data-no-auto-focus="true"> <input type="text" class="input" name="keywords" placeholder="Search…" aria-label="Search" /> <div class="menu menu--structural menu--search" aria-hidden="true"> <div class="menu-content"> <div class="menu-row"> <select name="constraints" class="js-quickSearch-constraint input" aria-label="Search within"> <option value="">Everywhere</option> <option value="{"search_type":"post"}">Threads</option> <option value="{"search_type":"post","c":{"nodes":[700],"child_nodes":1}}">This forum</option> <option value="{"search_type":"post","c":{"thread":1786807}}">This thread</option> </select> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[container_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles and first posts only</span></label> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[title_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles only</span></label> </div> <div class="menu-row"> <div class="inputGroup"> <span class="inputGroup-text" id="ctrl_search_menu_by_member">By:</span> <input type="text" class="input" name="c[users]" data-xf-init="auto-complete" placeholder="Member" aria-labelledby="ctrl_search_menu_by_member" /> </div> </div> <div class="menu-footer"> <span class="menu-footer-controls"> <button type="submit" class="button--primary button button--icon button--icon--search"><span class="button-text">Search</span></button> <a href="/search/" class="button"><span class="button-text">Advanced search…</span></a> </span> </div> <input type="hidden" name="_xfToken" value="1732703774,f84313c26c795512a068fea778443cf2" /> </div> </div> </form> </div> </div> </div> </header> <div class="xb-content-wrapper"> <div class="navigation-helper"></div> <div class="p-navSticky p-navSticky--primary" data-xf-init="sticky-header"> <div class="p-nav--wrapper"> <nav class="p-nav"> <div class="p-nav-inner"> <button type="button" class="button--plain p-nav-menuTrigger button" data-xf-click="off-canvas" data-menu=".js-headerOffCanvasMenu" tabindex="0" aria-label="Menu"><span class="button-text"> <i aria-hidden="true"></i> </span></button> <div class="p-nav-smallLogo"> <a href="https://www.tek-tips.com"> <img src="/styles/nova/tek-tips/header-logo.png" srcset="" alt="Tek-Tips" width="" height="" /> </a> </div> <div class="p-nav-scroller hScroller" data-xf-init="h-scroller" data-auto-scroll=".p-navEl.is-selected"> <div class="hScroller-scroll"> <ul class="p-nav-list js-offCanvasNavSource"> <li class="navhome"> <div class="p-navEl " > <a href="https://www.tek-tips.com" class="p-navEl-link " data-xf-key="1" data-nav-id="home">Home</a> </div> </li> <li class="navforums"> <div class="p-navEl is-selected" data-has-children="true"> <a href="/" class="p-navEl-link p-navEl-link--splitMenu " data-nav-id="forums">Forums</a> <a data-xf-key="2" data-xf-click="menu" data-menu-pos-ref="< .p-navEl" class="p-navEl-splitTrigger" role="button" tabindex="0" aria-label="Toggle expanded" aria-expanded="false" aria-haspopup="true"></a> <div class="menu menu--structural" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <a href="/whats-new/posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="newPosts">New posts</a> <a href="/search/?type=post" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="searchForums">Search forums</a> <a href="/forums/microsoft-access-tables-and-relationships.700/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="0">Forum</a> <a href="/forums/700/faqs/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy faqLink" data-nav-id="1">FAQs</a> <a href="/forums/700/links/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="2">Links</a> <a href="/forums/700/mvps/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy mvpLink" data-nav-id="3">MVPs</a> </div> </div> </div> </li> <li class="navwhatsNew"> <div class="p-navEl " data-has-children="true"> <a href="/whats-new/" class="p-navEl-link p-navEl-link--splitMenu " data-nav-id="whatsNew">What's new</a> <a data-xf-key="3" data-xf-click="menu" data-menu-pos-ref="< .p-navEl" class="p-navEl-splitTrigger" role="button" tabindex="0" aria-label="Toggle expanded" aria-expanded="false" aria-haspopup="true"></a> <div class="menu menu--structural" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <a href="/whats-new/posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="whatsNewPosts">New posts</a> <a href="/whats-new/profile-posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="whatsNewProfilePosts">New profile posts</a> <a href="/whats-new/latest-activity" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="latestActivity">Latest activity</a> </div> </div> </div> </li> <li class="navmembers"> <div class="p-navEl " data-has-children="true"> <a href="/members/" class="p-navEl-link p-navEl-link--splitMenu " data-nav-id="members">Members</a> <a data-xf-key="4" data-xf-click="menu" data-menu-pos-ref="< .p-navEl" class="p-navEl-splitTrigger" role="button" tabindex="0" aria-label="Toggle expanded" aria-expanded="false" aria-haspopup="true"></a> <div class="menu menu--structural" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <a href="/online/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="currentVisitors">Current visitors</a> <a href="/whats-new/profile-posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="newProfilePosts">New profile posts</a> <a href="/search/?type=profile_post" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="searchProfilePosts">Search profile posts</a> </div> </div> </div> </li> </ul> </div> </div> <div class="p-nav-opposite"> <div class="p-navgroup p-account p-navgroup--guest"> <a href="/login/" class="p-navgroup-link p-navgroup-link--textual p-navgroup-link--logIn" data-xf-click="overlay" data-follow-redirects="on"> <span class="p-navgroup-linkText">Log in</span> </a> <a href="/register/" class="p-navgroup-link p-navgroup-link--textual p-navgroup-link--register" data-xf-click="overlay" data-follow-redirects="on"> <span class="p-navgroup-linkText">Register</span> </a> </div> <div class="p-navgroup p-discovery"> <a href="/whats-new/" class="p-navgroup-link p-navgroup-link--iconic p-navgroup-link--whatsnew" aria-label="What's new" title="What's new"> <i aria-hidden="true"></i> <span class="p-navgroup-linkText">What's new</span> </a> <a href="/search/" class="p-navgroup-link p-navgroup-link--iconic p-navgroup-link--search" data-xf-click="menu" data-xf-key="/" aria-label="Search" aria-expanded="false" aria-haspopup="true" title="Search"> <i aria-hidden="true"></i> <span class="p-navgroup-linkText">Search</span> </a> <div class="menu menu--structural menu--wide" data-menu="menu" aria-hidden="true"> <form action="/search/search" method="post" class="menu-content" data-xf-init="quick-search" data-autocomplete-filter="["post"]"> <h3 class="menu-header">Search</h3> <div class="menu-row"> <div class="inputGroup inputGroup--joined"> <input type="text" class="input" name="keywords" placeholder="Search…" aria-label="Search" data-menu-autofocus="true" /> <select name="constraints" class="js-quickSearch-constraint input" aria-label="Search within"> <option value="">Everywhere</option> <option value="{"search_type":"post"}">Threads</option> <option value="{"search_type":"post","c":{"nodes":[700],"child_nodes":1}}">This forum</option> <option value="{"search_type":"post","c":{"thread":1786807}}" data-suggest-optout="1">This thread</option> </select> </div> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[container_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles and first posts only</span></label> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[title_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles only</span></label> </div> <div class="menu-row"> <div class="inputGroup"> <span class="inputGroup-text" id="ctrl_search_menu_by_member">By:</span> <input type="text" class="input" name="c[users]" data-xf-init="auto-complete" placeholder="Member" aria-labelledby="ctrl_search_menu_by_member" /> </div> </div> <div class="menu-footer"> <span class="menu-footer-controls"> <button type="submit" class="button--primary button button--icon button--icon--search"><span class="button-text">Search</span></button> <a href="/search/" class="button"><span class="button-text">Advanced search…</span></a> </span> </div> <input type="hidden" name="_xfToken" value="1732703774,f84313c26c795512a068fea778443cf2" /> </form> </div> </div> </div> </div> </nav> </div> </div> <div class="p-sectionLinks--wrapper"> <div class="p-sectionLinks"> <div class="p-sectionLinks-inner"> <div class="hScroller" data-xf-init="h-scroller"> <div class="hScroller-scroll"> <ul class="p-sectionLinks-list"> <li> <div class="p-navEl " > <a href="/whats-new/posts/" class="p-navEl-link " data-xf-key="alt+1" data-nav-id="newPosts">New posts</a> </div> </li> <li> <div class="p-navEl " > <a href="/search/?type=post" class="p-navEl-link " data-xf-key="alt+2" data-nav-id="searchForums">Search forums</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/microsoft-access-tables-and-relationships.700/" class="p-navEl-link " data-xf-key="alt+3" data-nav-id="0">Forum</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/700/faqs/" class="p-navEl-link faqLink" data-xf-key="alt+4" data-nav-id="1">FAQs</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/700/links/" class="p-navEl-link " data-xf-key="alt+5" data-nav-id="2">Links</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/700/mvps/" class="p-navEl-link mvpLink" data-xf-key="alt+6" data-nav-id="3">MVPs</a> </div> </li> </ul> </div> </div> <div class="p-sectionLinks-right"> </div> </div> </div> </div> <div class="offCanvasMenu offCanvasMenu--nav js-headerOffCanvasMenu" data-menu="menu" aria-hidden="true" data-ocm-builder="navigation"> <div class="offCanvasMenu-backdrop" data-menu-close="true"></div> <div class="offCanvasMenu-content"> <div class="offCanvasMenu-content--inner"> <div class="offCanvasMenu-header"> Menu <a class="offCanvasMenu-closer" data-menu-close="true" role="button" tabindex="0" aria-label="Close"></a> </div> <div class="p-offCanvasRegisterLink"> <div class="offCanvasMenu-linkHolder"> <a href="/login/" class="offCanvasMenu-link" data-xf-click="overlay" data-menu-close="true"> Log in </a> </div> <hr class="offCanvasMenu-separator" /> <div class="offCanvasMenu-linkHolder"> <a href="/register/" class="offCanvasMenu-link" data-xf-click="overlay" data-menu-close="true"> Register </a> </div> <hr class="offCanvasMenu-separator" /> </div> <div class="offCanvasMenu-subHeader">Navigation</div> <div class="js-offCanvasNavTarget"></div> <div class="offCanvasMenu-installBanner js-installPromptContainer" style="display: none;" data-xf-init="install-prompt"> <div class="offCanvasMenu-installBanner-header">Install the app</div> <button type="button" class="js-installPromptButton button"><span class="button-text">Install</span></button> <template class="js-installTemplateIOS"> <div class="overlay-title">How to install the app on iOS</div> <div class="block-body"> <div class="block-row"> <p> Follow along with the video below to see how to install our site as a web app on your home screen. </p> <p style="text-align: center"> <video src="/styles/default/xenforo/add_to_home.mp4" width="280" height="480" autoplay loop muted playsinline></video> </p> <p> <small><strong>Note:</strong> This feature may not be available in some browsers.</small> </p> </div> </div> </template> </div> <div class="offCanvasMenu-subHeader">More options</div> <div class="offCanvasMenu-linkHolder"> <a href="/misc/contact" class="offCanvasMenu-link" data-menu-close="true" data-nav-id="contactUs" data-xf-click="overlay">Contact us</a> </div> <div class="offCanvasMenu-linkHolder"> <a class="offCanvasMenu-link" data-menu-close="true" data-nav-id="closeMenu" role="button" tabindex="0" aria-label="Close">Close Menu</a> </div> </div> </div> </div> <div class="p-body"> <div class="p-body-inner"> <div class="xb-welcome-notice"> <div class="xb-welcome-notice--mask"> <div class="xb-welcome-notice--inner"> <div class="xb-welcome-notice--title"> <h3>Tek-Tips is the largest IT community on the Internet today!</h3> <h4>Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!</h4> </div> <div class="xb-welcome-notice--buttons"> <a href="/register/" class="button" data-xf-click="overlay" data-follow-redirects="on"><span class="button-text">Register</span></a> <a href="/login/" class="button--cta button" rel="nofollow" data-xf-click="overlay" data-menu-close="true"> <span class="button-text">Log in</span> </a> </div> </div> </div> </div>  <ul class="notices notices--block js-notices" data-xf-init="notices" data-type="block" data-scroll-interval="6"> <li class="notice js-notice notice--light" data-notice-id="15" data-delay-duration="0" data-display-duration="0" data-auto-dismiss="" data-visibility=""> <div class="notice-content"> <b>Congratulations <span><a href="/members/mike-lewis.388080/">Mike Lewis</a></span></b> on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go! </div> </li> </ul> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread1'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread1'); }); </script> </div> </div> </div><div> <div class="p-breadcrumbs--parent "> <ul class="p-breadcrumbs " itemscope itemtype="https://schema.org/BreadcrumbList"> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="https://www.tek-tips.com" itemprop="item"> <span itemprop="name">Home</span> </a> <meta itemprop="position" content="1" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/" itemprop="item"> <span itemprop="name">Forums</span> </a> <meta itemprop="position" content="2" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/#software.1001" itemprop="item"> <span itemprop="name">Software</span> </a> <meta itemprop="position" content="3" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/programmers.1004/" itemprop="item"> <span itemprop="name">Programmers</span> </a> <meta itemprop="position" content="4" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/dbms-packages.10027/" itemprop="item"> <span itemprop="name">DBMS Packages</span> </a> <meta itemprop="position" content="5" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/forums/microsoft-access-tables-and-relationships.700/" itemprop="item"> <span itemprop="name">Microsoft: Access Tables and Relationships</span> </a> <meta itemprop="position" content="6" /> </li> </ul> </div> <noscript class="js-jsWarning"><div class="blockMessage blockMessage--important blockMessage--iconic u-noJsOnly">JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.</div></noscript> <div class="blockMessage blockMessage--important blockMessage--iconic js-browserWarning" style="display: none">You are using an out of date browser. It may not display this or other websites correctly.<br />You should upgrade or use an <a href="https://www.google.com/chrome/" target="_blank" rel="noopener">alternative browser</a>.</div>  <div class="p-body-header"> <div class="p-title "> <h1 class="p-title-value">HOW TO : Show NULLs in Table View </h1> </div> <div class="p-description"> <ul class="listInline listInline--bullet"> <li> <i class="fa--xf fal fa-user" aria-hidden="true" title="Thread starter"></i> <span class="u-srOnly">Thread starter</span> <a href="/members/cp950.50482/" class="username u-concealed" dir="auto" data-user-id="50482" data-xf-init="member-tooltip">cp950</a> </li> <li> <i class="fa--xf fal fa-clock" aria-hidden="true" title="Start date"></i> <span class="u-srOnly">Start date</span> <a href="/threads/how-to-show-nulls-in-table-view.1786807/" class="u-concealed"><time class="u-dt" dir="auto" datetime="2018-05-10T10:07:38+0100" data-time="1525943258" data-date-string="May 10, 2018" data-time-string="10:07 AM" title="May 10, 2018 at 10:07 AM">May 10, 2018</time></a> </li> </ul> </div> </div>  <div class="p-body-main p-body-main--withSidebar "> <div class="p-body-contentCol"></div> <div class="p-body-sidebarCol"></div> <div class="p-body-content">  <div id='div-gpt-tektips_wallpaper'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_wallpaper'); }); </script> </div> <div class="p-body-pageContent"> <div class="block block--messages " data-xf-init="lightbox select-to-quote" data-message-selector=".js-post" data-lb-id="thread-1786807"> <div class="block-outer"> <dl class="blockStatus"> <dt>Status</dt> <dd class="blockStatus-message blockStatus-message--locked"> Not open for further replies. </dd> </dl> </div> <div class="block-outer"></div> <div class="block-outer js-threadStatusField"></div> <div class="block-container"> <div class="block-body"> <article class="message message--post js-post js-inlineModContainer " data-author="cp950" data-content="post-7393747" id="js-post-7393747" > <span class="u-anchorTarget" id="post-7393747"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/how-to-show-nulls-in-table-view.1786807/post-7393747" rel="nofollow" > <time class="u-dt" dir="auto" datetime="2018-05-10T10:07:38+0100" data-time="1525943258" data-date-string="May 10, 2018" data-time-string="10:07 AM" title="May 10, 2018 at 10:07 AM">May 10, 2018</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li> <a href="/threads/how-to-show-nulls-in-table-view.1786807/post-7393747" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7393747/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/how-to-show-nulls-in-table-view.1786807/post-7393747" rel="nofollow"> #1 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" > <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/cp950.50482/" class="avatar avatar--s" data-user-id="50482" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="cp950" class="avatar-u50482-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/cp950.50482/" class="username " dir="auto" data-user-id="50482" data-xf-init="member-tooltip">cp950</a></h4> <h5 class="userTitle message-userTitle" dir="auto">Programmer</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>Dec 18, 2000</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>19</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7393747" data-lb-caption-desc="cp950 · May 10, 2018 at 10:07 AM"> <article class="message-body js-selectToQuote"> <div > <div class="bbWrapper">I know SQL_Server does it.<br /> <br /> <b>Is there an MS_Access option that'll show NULL fields as something other than blank?</b><br /> Zero-Length would look like " "<br /> Space would look like " "<br /> NULL would look something like "<i><<null>></i>".<br /> <br /> I have a DB with poor NULL handling and it would be a huge research help...<br /> <br /></div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> </div> </article> </div> </div> </div> <div class="block block--messages" data-xf-init="" data-type="post" data-href="/inline-mod/" data-search-target="*"> <span class="u-anchorTarget" id="posts"></span> <div class="block-outer"><div class="block-outer-opposite"> <div class="tabs tabs--standalone tabs--standalone--small tabs--standalone--inline"> <a href="/threads/how-to-show-nulls-in-table-view.1786807/" class="tabs-tab is-active" rel="nofollow"> Sort by date </a> <a href="/threads/how-to-show-nulls-in-table-view.1786807/?order=vote_score" class="tabs-tab " rel="nofollow"> Sort by votes </a> </div> </div></div> <div class="block-container lbContainer" data-xf-init="lightbox select-to-quote" data-message-selector=".js-post" data-lb-id="thread-1786807" data-lb-universal="0"> <div class="block-body js-replyNewMessageContainer"> <article class="message message--post js-post js-inlineModContainer " data-author="dhookom" data-content="post-7393755" id="js-post-7393755" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7393755/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/how-to-show-nulls-in-table-view.1786807/" /> <span class="u-anchorTarget" id="post-7393755"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/how-to-show-nulls-in-table-view.1786807/post-7393755" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2018-05-10T11:06:45+0100" data-time="1525946805" data-date-string="May 10, 2018" data-time-string="11:06 AM" title="May 10, 2018 at 11:06 AM" itemprop="datePublished">May 10, 2018</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li> <a href="/threads/how-to-show-nulls-in-table-view.1786807/post-7393755" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7393755/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/how-to-show-nulls-in-table-view.1786807/post-7393755" rel="nofollow"> #2 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/dhookom.529593/"> <meta itemprop="url" content="https://www.tek-tips.com/members/dhookom.529593/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/dhookom.529593/" class="avatar avatar--s" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" srcset="/data/avatars/m/529/529593.jpg?1723729896 2x" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip"><span itemprop="name">dhookom</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Programmer</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>Jun 24, 2003</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>22,510</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7393755" data-lb-caption-desc="dhookom · May 10, 2018 at 11:06 AM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">For numeric fields displayed in text boxes on forms you can use the format property like:<br /> 0.00;(0.00);0;"Null"<br /> <br /> I expect this doesn't work for text field but you can use Conditional Formatting.<br /> <br /> <span style="color: Blue"><b><i>Duane<br /> Minnesota<br /> <a href="http://www.access.hookom.net/" target="_blank" class="link link--external" rel="nofollow ugc noopener">Hook'D on Access</a><br /> MS Access MVP 2001-2016<br /> </i></b></span></div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7393755"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> <article class="message message--post js-post js-inlineModContainer " data-author="dhookom" data-content="post-7393757" id="js-post-7393757" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7393757/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/how-to-show-nulls-in-table-view.1786807/" /> <span class="u-anchorTarget" id="post-7393757"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/how-to-show-nulls-in-table-view.1786807/post-7393757" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2018-05-10T11:22:37+0100" data-time="1525947757" data-date-string="May 10, 2018" data-time-string="11:22 AM" title="May 10, 2018 at 11:22 AM" itemprop="datePublished">May 10, 2018</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li> <a href="/threads/how-to-show-nulls-in-table-view.1786807/post-7393757" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7393757/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/how-to-show-nulls-in-table-view.1786807/post-7393757" rel="nofollow"> #3 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/dhookom.529593/"> <meta itemprop="url" content="https://www.tek-tips.com/members/dhookom.529593/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/dhookom.529593/" class="avatar avatar--s" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" srcset="/data/avatars/m/529/529593.jpg?1723729896 2x" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip"><span itemprop="name">dhookom</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Programmer</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>Jun 24, 2003</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>22,510</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7393757" data-lb-caption-desc="dhookom · May 10, 2018 at 11:22 AM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">I just realized you specified "table view". The options I suggested will work in datasheet view which is similar to table view.<br /> <br /> <span style="color: Blue"><b><i>Duane<br /> Minnesota<br /> <a href="http://www.access.hookom.net/" target="_blank" class="link link--external" rel="nofollow ugc noopener">Hook'D on Access</a><br /> MS Access MVP 2001-2016<br /> </i></b></span></div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7393757"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> </div> </div> <div class="block-outer block-outer--after"> <dl class="blockStatus"> <dt>Status</dt> <dd class="blockStatus-message blockStatus-message--locked"> Not open for further replies. </dd> </dl> </div> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread3'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread3'); }); </script> </div></div></div> <div class="block" data-widget-id="11" data-widget-key="xfes_thread_view_below_quick_reply_similar_threads" data-widget-definition="xfes_similar_threads"> <div class="block-container"> <h3 class="block-header">Similar threads</h3> <div class="block-body"> <div class="structItemContainer"> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1820070" data-author="raywood1"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/raywood1.1102335/" class="avatar avatar--s" data-user-id="1102335" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="raywood1" class="avatar-u1102335-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/reducing-a-massive-linked-table.1820070/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/reducing-a-massive-linked-table.1820070/preview">Reducing a Massive Linked Table</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/raywood1.1102335/" class="username " dir="auto" data-user-id="1102335" data-xf-init="member-tooltip">raywood1</a></li> <li class="structItem-startDate"><a href="/threads/reducing-a-massive-linked-table.1820070/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2023-01-11T04:10:00+0000" data-time="1673410200" data-date-string="Jan 11, 2023" data-time-string="4:10 AM" title="Jan 11, 2023 at 4:10 AM">Jan 11, 2023</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>4</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>296</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/reducing-a-massive-linked-table.1820070/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2023-01-14T22:49:00+0000" data-time="1673736540" data-date-string="Jan 14, 2023" data-time-string="10:49 PM" title="Jan 14, 2023 at 10:49 PM">Jan 14, 2023</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1811302" data-author="MrStohler"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/mrstohler.415870/" class="avatar avatar--s" data-user-id="415870" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="MrStohler" class="avatar-u415870-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/beginner-q-how-to-separate-data-from-excel-into-related-tables-and-maintain-relationship.1811302/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/beginner-q-how-to-separate-data-from-excel-into-related-tables-and-maintain-relationship.1811302/preview">Beginner Q: How to separate data from Excel into related tables and maintain relationship?</a> <span class="votesInfo" data-xf-init="tooltip" title="1 member likes this thread!" >1</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/mrstohler.415870/" class="username " dir="auto" data-user-id="415870" data-xf-init="member-tooltip">MrStohler</a></li> <li class="structItem-startDate"><a href="/threads/beginner-q-how-to-separate-data-from-excel-into-related-tables-and-maintain-relationship.1811302/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2021-08-10T11:29:17+0100" data-time="1628591357" data-date-string="Aug 10, 2021" data-time-string="11:29 AM" title="Aug 10, 2021 at 11:29 AM">Aug 10, 2021</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>5</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>262</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/beginner-q-how-to-separate-data-from-excel-into-related-tables-and-maintain-relationship.1811302/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2021-08-11T16:01:36+0100" data-time="1628694096" data-date-string="Aug 11, 2021" data-time-string="4:01 PM" title="Aug 11, 2021 at 4:01 PM">Aug 11, 2021</time></a> <div class="structItem-minor"> <a href="/members/skipvought.166621/" class="username " dir="auto" data-user-id="166621" data-xf-init="member-tooltip">SkipVought</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/skipvought.166621/" class="avatar avatar--xxs avatar--default avatar--default--dynamic" data-user-id="166621" data-xf-init="member-tooltip" style="background-color: #cc3352; color: #f0c2cb"> <span class="avatar-u166621-s" role="img" aria-label="SkipVought">S</span> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1807066" data-author="03Explorer"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/03explorer.1060185/" class="avatar avatar--s" data-user-id="1060185" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="03Explorer" class="avatar-u1060185-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/preview">Refreshing a linked table (housed on MS SQL Server) now breaks</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/03explorer.1060185/" class="username " dir="auto" data-user-id="1060185" data-xf-init="member-tooltip">03Explorer</a></li> <li class="structItem-startDate"><a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2020-11-13T22:22:57+0000" data-time="1605306177" data-date-string="Nov 13, 2020" data-time-string="10:22 PM" title="Nov 13, 2020 at 10:22 PM">Nov 13, 2020</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>3</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>230</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2020-12-02T15:23:21+0000" data-time="1606922601" data-date-string="Dec 2, 2020" data-time-string="3:23 PM" title="Dec 2, 2020 at 3:23 PM">Dec 2, 2020</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1796260" data-author="BugZap13"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/bugzap13.1653487/" class="avatar avatar--s" data-user-id="1653487" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="BugZap13" class="avatar-u1653487-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/preview">How to extract Access table schema with decimal places on numeric fields?</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/bugzap13.1653487/" class="username " dir="auto" data-user-id="1653487" data-xf-init="member-tooltip">BugZap13</a></li> <li class="structItem-startDate"><a href="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2019-08-05T10:00:43+0100" data-time="1564995643" data-date-string="Aug 5, 2019" data-time-string="10:00 AM" title="Aug 5, 2019 at 10:00 AM">Aug 5, 2019</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>2</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>688</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2019-08-05T12:04:40+0100" data-time="1565003080" data-date-string="Aug 5, 2019" data-time-string="12:04 PM" title="Aug 5, 2019 at 12:04 PM">Aug 5, 2019</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1813269" data-author="JayRo71"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/jayro71.1692646/" class="avatar avatar--s" data-user-id="1692646" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="JayRo71" class="avatar-u1692646-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/importing-only-unique-records-from-excel-tables.1813269/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/importing-only-unique-records-from-excel-tables.1813269/preview">Importing only unique records from excel tables </a> <span class="votesInfo" data-xf-init="tooltip" title="1 member likes this thread!" >1</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/jayro71.1692646/" class="username " dir="auto" data-user-id="1692646" data-xf-init="member-tooltip">JayRo71</a></li> <li class="structItem-startDate"><a href="/threads/importing-only-unique-records-from-excel-tables.1813269/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2022-01-06T15:46:59+0000" data-time="1641484019" data-date-string="Jan 6, 2022" data-time-string="3:46 PM" title="Jan 6, 2022 at 3:46 PM">Jan 6, 2022</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>10</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>386</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/importing-only-unique-records-from-excel-tables.1813269/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2022-01-11T19:15:36+0000" data-time="1641928536" data-date-string="Jan 11, 2022" data-time-string="7:15 PM" title="Jan 11, 2022 at 7:15 PM">Jan 11, 2022</time></a> <div class="structItem-minor"> <a href="/members/skipvought.166621/" class="username " dir="auto" data-user-id="166621" data-xf-init="member-tooltip">SkipVought</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/skipvought.166621/" class="avatar avatar--xxs avatar--default avatar--default--dynamic" data-user-id="166621" data-xf-init="member-tooltip" style="background-color: #cc3352; color: #f0c2cb"> <span class="avatar-u166621-s" role="img" aria-label="SkipVought">S</span> </a> </div> </div> </div> </div> </div> </div> </div> <div class="blockMessage blockMessage--none"> <div class="shareButtons shareButtons--iconic" data-xf-init="share-buttons" data-page-url="" data-page-title="" data-page-desc="" data-page-image=""> <span class="shareButtons-label">Share:</span> <div class="shareButtons-buttons"> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--facebook" data-href="https://www.facebook.com/sharer.php?u={url}"> <i aria-hidden="true"></i> <span>Facebook</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--twitter" data-href="https://twitter.com/intent/tweet?url={url}&text={title}"> <svg xmlns="http://www.w3.org/2000/svg" height="1em" viewBox="0 0 512 512" class=""><path d="M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z"/></svg> <span>X (Twitter)</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--reddit" data-href="https://reddit.com/submit?url={url}&title={title}"> <i aria-hidden="true"></i> <span>Reddit</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--pinterest" data-href="https://pinterest.com/pin/create/bookmarklet/?url={url}&description={title}&media={image}"> <i aria-hidden="true"></i> <span>Pinterest</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--tumblr" data-href="https://www.tumblr.com/widgets/share/tool?canonicalUrl={url}&title={title}"> <i aria-hidden="true"></i> <span>Tumblr</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--whatsApp" data-href="https://api.whatsapp.com/send?text={title} {url}"> <i aria-hidden="true"></i> <span>WhatsApp</span> </a> <a class="shareButtons-button shareButtons-button--email" data-href="mailto:?subject={title}&body={url}"> <i aria-hidden="true"></i> <span>Email</span> </a> <a class="shareButtons-button shareButtons-button--share is-hidden" data-xf-init="web-share" data-title="" data-text="" data-url="" data-hide=".shareButtons-button:not(.shareButtons-button--share)"> <i aria-hidden="true"></i> <span>Share</span> </a> <a class="shareButtons-button shareButtons-button--link is-hidden" data-clipboard="{url}"> <i aria-hidden="true"></i> <span>Link</span> </a> </div> </div> </div> </div> </div> <div class="p-sidebarWrapper"> <div class="p-body-sidebar"> <div class="block block--login"> <form action="/login/login" method="post" class="" > <input type="hidden" name="_xfToken" value="1732703774,f84313c26c795512a068fea778443cf2" /> <div class="block-container"> <h3 class="block-minorHeader"> Log in </h3> <div class="block-body"> <div class="block-row"> <dl class="formRow formRow--input"> <dt> <div class="formRow-labelWrapper"> <label class="formRow-label" for="_xfUid-1-1732703774">Your name or email address</label></div> </dt> <dd> <input type="text" class="input" name="login" autocomplete="username" id="_xfUid-1-1732703774" /> </dd> </dl> <dl class="formRow formRow--input"> <dt> <div class="formRow-labelWrapper"> <label class="formRow-label" for="_xfUid-2-1732703774">Password</label></div> </dt> <dd> <input type="password" class="input" name="password" autocomplete="current-password" id="_xfUid-2-1732703774" /> <a href="/lost-password/" data-xf-click="overlay">Forgot your password?</a> </dd> </dl> <dl class="formRow"> <dt> <div class="formRow-labelWrapper"></div> </dt> <dd> <ul class="inputChoices"> <li class="inputChoices-choice"><label class="iconic"><input type="checkbox" name="remember" value="1" checked="checked" /><i aria-hidden="true"></i><span class="iconic-label">Stay logged in</span></label></li> </ul> </dd> </dl> <dl class="formRow formSubmitRow"> <dt></dt> <dd> <div class="formSubmitRow-main"> <div class="formSubmitRow-bar"></div> <div class="formSubmitRow-controls"><button type="submit" class="button--primary button button--icon button--icon--login"><span class="button-text">Log in</span></button></div> </div> </dd> </dl> <dl class="formRow formRegisterRow"> <dt></dt> <dd>Don't have an account? <a href="/register/" data-xf-click="overlay" data-follow-redirects="on">Register now</a></dd> </dl> </div> </div> </div> </form> </div> <div class="block"> <div class="block-container" data-widget-id="18" data-widget-key="right_search_top" data-widget-definition="html"> <h3 class="block-minorHeader">Part and Inventory Search</h3> <div class="block-body block-row"> <center><div id='div-gpt-tektips_customsearchbox'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_customsearchbox'); }); </script> </div> </center> </div> </div> </div> <div class="block"> <div class="block-container" data-widget-id="13" data-widget-key="right_rail_middle_bottom_ga" data-widget-definition="html"> <h3 class="block-minorHeader">Sponsor</h3> <div class="block-body block-row"> <center> <div id='div-gpt-tektips_sidebar1'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_sidebar1'); }); </script> </div> </center> </div> </div> </div> </div> </div> </div> <div class="p-breadcrumbs--parent p-breadcrumbs--bottom"> <ul class="p-breadcrumbs p-breadcrumbs--bottom" itemscope itemtype="https://schema.org/BreadcrumbList"> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="https://www.tek-tips.com" itemprop="item"> <span itemprop="name">Home</span> </a> <meta itemprop="position" content="1" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/" itemprop="item"> <span itemprop="name">Forums</span> </a> <meta itemprop="position" content="2" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/#software.1001" itemprop="item"> <span itemprop="name">Software</span> </a> <meta itemprop="position" content="3" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/programmers.1004/" itemprop="item"> <span itemprop="name">Programmers</span> </a> <meta itemprop="position" content="4" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/dbms-packages.10027/" itemprop="item"> <span itemprop="name">DBMS Packages</span> </a> <meta itemprop="position" content="5" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/forums/microsoft-access-tables-and-relationships.700/" itemprop="item"> <span itemprop="name">Microsoft: Access Tables and Relationships</span> </a> <meta itemprop="position" content="6" /> </li> </ul> </div> </div> </div> </div>  <footer class="p-footer" id="footer"> <div class="p-footer--container footer-stretched"> <div class="p-footer-default"> <div class="p-footer-inner"> <div class="p-footer-row"> <div class="p-footer-row-main"> <ul class="p-footer-linkList"> <li class="p-linkList-changeStyle"><a href="/misc/style" data-xf-click="overlay" data-xf-init="tooltip" title="Style: TekTips" rel="nofollow"> Style chooser </a></li> <li class="p-linkList-changeWidth"><a class="pageWidthToggle xb-toggle-default" role="button" tabindex="0" data-xf-click="toggle" data-target="html" data-active-class="xb-toggle-default" data-xf-init="toggle-storage" data-storage-type="cookie" data-storage-expiry="31556926" data-storage-key="_xb-width"> Change width </a></li> </ul> </div> <div class="p-footer-row-opposite"> <ul class="p-footer-linkList"> <li><a href="/misc/contact" data-xf-click="overlay">Contact us</a></li> <li><a href="/help/terms/">Terms and rules</a></li> <li><a href="/help/privacy-policy/">Privacy policy</a></li> <li><a href="/help/">Help</a></li> <li><a href="https://www.tek-tips.com">Home</a></li> <li><a href="/forums/-/index.rss" target="_blank" class="p-footer-rssLink" title="RSS"><span aria-hidden="true"><i class="fa--xf fal fa-rss" aria-hidden="true"></i><span class="u-srOnly">RSS</span></span></a></li> </ul> </div> </div> </div> </div> <div class="p-footer-copyright"> <div class="p-footer-inner"> <div class="p-footer-copyright--flex"> <div class="copyright-left"> Copyright © <script type="text/javascript">d = new Date();y = d.getFullYear();document.write(y);</script> WTWH Media, LLC. All Rights Reserved. </div> </div> </div> </div> </div> </footer> </div>  </div>  <div class="u-bottomFixer js-bottomFixTarget"> <ul class="notices notices--bottom_fixer js-notices" data-xf-init="notices" data-type="bottom_fixer" data-scroll-interval="6"> <li class="notice js-notice notice--primary notice--cookie" data-notice-id="-1" data-delay-duration="0" data-display-duration="0" data-auto-dismiss="0" data-visibility=""> <div class="notice-content"> <div class="u-alignCenter"> This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.<br /> By continuing to use this site, you are consenting to our use of cookies. </div> <div class="u-inputSpacer u-alignCenter"> <a href="/account/dismiss-notice" class="js-noticeDismiss button--notice button button--icon button--icon--confirm"><span class="button-text">Accept</span></a> <a href="/help/cookies" class="button--notice button"><span class="button-text">Learn more…</span></a> </div> </div> </li> </ul> </div> <div class="u-navButtons js-navButtons" data-trigger-type="up"> <a href="javascript:" class="button--scroll button"><span class="button-text"><i class="fa--xf fal fa-arrow-left" aria-hidden="true"></i><span class="u-srOnly">Back</span></span></a> </div> <div class="u-scrollButtons js-scrollButtons" data-trigger-type="up"> <a href="#top" class="button--scroll button" data-xf-click="scroll-to"><span class="button-text"><i class="fa--xf fal fa-arrow-up" aria-hidden="true"></i><span class="u-srOnly">Top</span></span></a> </div> <script src="/js/vendor/jquery/jquery-3.5.1.min.js?_v=e65b7ca0"></script> <script src="/js/vendor/vendor-compiled.js?_v=e65b7ca0"></script> <script src="/js/xf/core-compiled.js?_v=e65b7ca0"></script> <script src="/js/sv/ese/xf/structure.min.js?_v=e65b7ca0"></script> <script src="/js/xf/notice.min.js?_v=e65b7ca0"></script> <script> $(".xb-searchWrapper").on("click", function(event) { $(".xb-searchWrapper").addClass("is-active"); event.stopPropagation(); }); $(".xb-searchWrapper").on("click", function(event) { event.stopPropagation(); }); $(document).on("click", function(event) { $(".xb-searchWrapper").removeClass("is-active"); }); </script> <script> jQuery.extend(true, XF.config, { // userId: 0, enablePush: false, pushAppServerKey: '', url: { fullBase: 'https://www.tek-tips.com/', basePath: '/', css: '/css.php?css=__SENTINEL__&s=3&l=1&d=1731063743', keepAlive: '/login/keep-alive' }, cookie: { path: '/', domain: '', prefix: 'xf_', secure: true, consentMode: 'simple', consented: ["optional","_third_party"] }, cacheKey: 'cf136c583e6591f869f990ac86545fee', csrf: '1732703774,f84313c26c795512a068fea778443cf2', js: {"\/js\/sv\/ese\/xf\/structure.min.js?_v=e65b7ca0":true,"\/js\/xf\/notice.min.js?_v=e65b7ca0":true}, css: {"public:message.less":true,"public:notices.less":true,"public:share_controls.less":true,"public:snog_groups.less":true,"public:structured_list.less":true,"public:svESE_autocomplete.less":true,"public:xb.less":true,"public:xb_search.less":true,"public:xb_sidebar_login.less":true,"public:xb_welcome.less":true,"public:xc_soft_attachment.less":true,"public:xc_votes_button.less":true,"public:extra.less":true}, time: { now: 1732703774, today: 1732665600, todayDow: 3, tomorrow: 1732752000, yesterday: 1732579200, week: 1732147200 }, borderSizeFeature: '2px', fontAwesomeWeight: 'l', enableRtnProtect: true, enableFormSubmitSticky: true, uploadMaxFilesize: 268435456, allowedVideoExtensions: ["m4v","mov","mp4","mp4v","mpeg","mpg","ogv","webm"], allowedAudioExtensions: ["mp3","opus","ogg","wav"], shortcodeToEmoji: true, visitorCounts: { conversations_unread: '0', alerts_unviewed: '0', total_unread: '0', title_count: true, icon_indicator: true }, jsState: {}, publicMetadataLogoUrl: '', publicPushBadgeUrl: 'https://www.tek-tips.com/styles/default/xenforo/bell.png' }); jQuery.extend(XF.phrases, { // date_x_at_time_y: "{date} at {time}", day_x_at_time_y: "{day} at {time}", yesterday_at_x: "Yesterday at {time}", x_minutes_ago: "{minutes} minutes ago", one_minute_ago: "1 minute ago", a_moment_ago: "A moment ago", today_at_x: "Today at {time}", in_a_moment: "In a moment", in_a_minute: "In a minute", in_x_minutes: "In {minutes} minutes", later_today_at_x: "Later today at {time}", tomorrow_at_x: "Tomorrow at {time}", day0: "Sunday", day1: "Monday", day2: "Tuesday", day3: "Wednesday", day4: "Thursday", day5: "Friday", day6: "Saturday", dayShort0: "Sun", dayShort1: "Mon", dayShort2: "Tue", dayShort3: "Wed", dayShort4: "Thu", dayShort5: "Fri", dayShort6: "Sat", month0: "January", month1: "February", month2: "March", month3: "April", month4: "May", month5: "June", month6: "July", month7: "August", month8: "September", month9: "October", month10: "November", month11: "December", active_user_changed_reload_page: "The active user has changed. Reload the page for the latest version.", server_did_not_respond_in_time_try_again: "The server did not respond in time. Please try again.", oops_we_ran_into_some_problems: "Oops! We ran into some problems.", oops_we_ran_into_some_problems_more_details_console: "Oops! We ran into some problems. Please try again later. More error details may be in the browser console.", file_too_large_to_upload: "The file is too large to be uploaded.", uploaded_file_is_too_large_for_server_to_process: "The uploaded file is too large for the server to process.", files_being_uploaded_are_you_sure: "Files are still being uploaded. Are you sure you want to submit this form?", attach: "Attach files", rich_text_box: "Rich text box", close: "Close", link_copied_to_clipboard: "Link copied to clipboard.", text_copied_to_clipboard: "Text copied to clipboard.", loading: "Loading…", you_have_exceeded_maximum_number_of_selectable_items: "You have exceeded the maximum number of selectable items.", processing: "Processing", 'processing...': "Processing…", showing_x_of_y_items: "Showing {count} of {total} items", showing_all_items: "Showing all items", no_items_to_display: "No items to display", number_button_up: "Increase", number_button_down: "Decrease", push_enable_notification_title: "Push notifications enabled successfully at Tek-Tips", push_enable_notification_body: "Thank you for enabling push notifications!", pull_down_to_refresh: "Pull down to refresh", release_to_refresh: "Release to refresh", refreshing: "Refreshing…" , "svStandardLib_time.day": "{count} day", "svStandardLib_time.days": "{count} days", "svStandardLib_time.hour": "{count} hour", "svStandardLib_time.hours": "{count} hours", "svStandardLib_time.minute": "{count} minutes", "svStandardLib_time.minutes": "{count} minutes", "svStandardLib_time.month": "{count} month", "svStandardLib_time.months": "{count} months", "svStandardLib_time.second": "{count} second", "svStandardLib_time.seconds": "{count} seconds", "svStandardLib_time.week": "time.week", "svStandardLib_time.weeks": "{count} weeks", "svStandardLib_time.year": "{count} year", "svStandardLib_time.years": "{count} years" }); </script> <form style="display:none" hidden="hidden"> <input type="text" name="_xfClientLoadTime" value="" id="_xfClientLoadTime" title="_xfClientLoadTime" tabindex="-1" /> </form>  <script type="application/ld+json"> { "@context": "https://schema.org", "@type": "QAPage", "url": "https://www.tek-tips.com/threads/how-to-show-nulls-in-table-view.1786807/", "mainEntity": { "@type": "Question", "@id": "https://www.tek-tips.com/threads/how-to-show-nulls-in-table-view.1786807/", "name": "HOW TO : Show NULLs in Table View", "datePublished": "2018-05-10T09:07:38+00:00", "url": "https://www.tek-tips.com/threads/how-to-show-nulls-in-table-view.1786807/", "text": "I know SQL_Server does it.\n\nIs there an MS_Access option that'll show NULL fields as something other than blank?\n Zero-Length would look like \" \"\n Space would look like \" \"\n NULL would look something like \"<<null>>\".\n\nI have a DB with poor NULL handling and it would be a huge research help...", "answerCount": 2, "upvoteCount": 0, "author": { "@type": "Person", "@id": "https://www.tek-tips.com/members/cp950.50482/", "name": "cp950", "url": "https://www.tek-tips.com/members/cp950.50482/" }, "suggestedAnswer": [ { "@type": "Answer", "datePublished": "2018-05-10T10:22:37+00:00", "url": "https://www.tek-tips.com/posts/7393757/", "text": "I just realized you specified \"table view\". The options I suggested will work in datasheet view which is similar to table view.\n\nDuane\nMinnesota\nHook'D on Access\nMS Access MVP 2001-2016", "upvoteCount": 0, "author": { "@type": "Person", "@id": "https://www.tek-tips.com/members/dhookom.529593/", "name": "dhookom", "url": "https://www.tek-tips.com/members/dhookom.529593/" } }, { "@type": "Answer", "datePublished": "2018-05-10T10:06:45+00:00", "url": "https://www.tek-tips.com/posts/7393755/", "text": "For numeric fields displayed in text boxes on forms you can use the format property like:\n0.00;(0.00);0;\"Null\"\n\nI expect this doesn't work for text field but you can use Conditional Formatting.\n\nDuane\nMinnesota\nHook'D on Access\nMS Access MVP 2001-2016", "upvoteCount": 0, "author": { "@type": "Person", "@id": "https://www.tek-tips.com/members/dhookom.529593/", "name": "dhookom", "url": "https://www.tek-tips.com/members/dhookom.529593/" } } ] }, "publisher": { "@type": "Organization", "name": "Tek-Tips", "alternateName": "Tek-Tips Information Technology Professional Forums", "description": "Tek-Tips Forums is an intelligent work forum community for Information Technology professionals.", "url": "https://www.tek-tips.com" } } </script> </body> </html>

CINXE.COM

HOW TO : Show NULLs in Table View - Microsoft: Access Tables and Relationships | Tek-Tips