By Richard Rost 3 years ago
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 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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Subscribe to Default Value
Get notifications when this page is updated