Allow/Disallow Data Entry with the Enabled Property

In this Microsoft Access tutorial I will show you how to enable or disable a field on a form based on the value in another field using conditional formatting, all without any programming or VBA required. You will learn how to set up rules so, for example, only customers from Florida can have a credit limit, how to handle null values, and how these rules work in both regular and continuous forms. This is an expert-level tip using the "Expression is" feature in conditional formatting.

Prerequisites

• Conditional Formatting
• Expression Is

Links

• Update Query
• Null Math
•  

Recommended Courses

• Access Advanced 2
• Access Advanced 3

Up Next

• Enabled, Part 2

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 Merch Store - Get your swag here! Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, conditional formatting expression, enable disable field based on value, disable form field by state, credit limit field Florida only, expression is conditional formatting, enable property without VBA, conditional formatting null values, disable fields continuous form, restrict data entry by state, macros for enabling fields, update query for field values, conditional formatting design view, customer form field enable, disable credit limit non-Florida