How to Set a Field's Default Value in Access

In this video, I will show you how to set a default value for new customers so you don't have to type in data that's the same for most of them. If most of your new clients are locals, for example, you don't have to keep typing in city, state, and ZIP code. I'll also show you how to set a default value for the date to equal today's date.

Joanna from Key West, Florida (a Gold Member) asks: About 99% of my customers are locals. Is there any way to make it so I don't have to type in the City, State, and ZIP Code every time I get a new customer?

Members

Members will learn how to use a form footer to provide that default value. This way if you want to enter a bunch of new records from, say, Florida, and then a bunch of new records from New York, you can set the default value in the footer, enter those records, then set the next one, and so on.

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

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!

Links

• ZIP Code Lookup: https://599cd.com/ZIPCode
• Access Beginner 3: https://599cd.com/ACB3

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 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.