Auto Number List Items in a Microsoft Access Form

In this Microsoft Access tutorial, I will show you how to number items in a continuous form without the convenience of a running sum property. You'll learn how to create a calculated field using the DCount function to display a sort order based on the CustomerID. We'll cover the use of functions like NZ to handle null values and explain the drawbacks of using DCount in larger datasets. This tutorial is designed for an expert level audience, bridging the gap between beginners and developers, and shows practical techniques for simple counting in smaller tables.

Members

In the extended cut, we will use a little VBA code to renumber the list based on whatever field the user sorts on. I will show you how to take into account any filters that are applied, ensuring the numbering is accurate and dynamic according to the sort order and filter conditions.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Numbered Report Items
• Calculated Fields
• DCount
• NZ Function

Links

• IIF Function

Recommended Courses

• Access Expert 1

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, number items continuous form, running sum property, calculated field, sort order, DCount function, display sort numbering, NZ function, null conversion, expert-level tutorial, control source properties, dynamic field calculation, CustomerID sorting, avoid VBA, efficiency considerations, continuous form limits, display count dynamically, IIf function, conditional counting