Get Form Field Default Value from Variable or Const

In this Microsoft Access tutorial I will teach you how to use a global variable or constant as a default value for a form field. We'll also talk about using TempVars for the same task.

Eduardo from Hollywood, Florida (a Gold Member) asks: If I have Global Const MyServer = "10.0.0.10" How do I put it in the Default Value for a field in a form? Apparently you can not put a global constant or variable there.

Prerequisites

• Intro to VBA: https://599cd.com/IntroVBA
• Variables: https://599cd.com/Variables
• Scope: https://599cd.com/Scope

Links

• Double Double Quotes: https://599cd.com/DoubleDouble

Recommended Courses

• Access Developer Courses: https://599cd.com/Developer

Usage

• FirstName.DefaultValue = "=""" & MYNAME & """"
• FamilySize.DefaultValue = "=" & MYNUMBER
• CustomerSince.DefaultValue = "=#" & MYDATE & "#"
• TempVars("FirstNameDefault") = "Rick"

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.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, form field, default value, vba, const, tempvars