Option Compare: Database v Binary v Text in VBA

In this Microsoft Access tutorial, you will learn how to utilize the Option Compare statement in VBA, exploring the differences between Database, Binary, and Text settings. Understand how these options affect string comparisons and sorting, and ensure accurate case-sensitive or case-insensitive searches in your Access applications.

Prerequisites

• Intro to VBA

Links

• InStr Function
• Option Explicit

Recommended Courses

• Access Developer Courses

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, Option Compare, Binary versus Text, Microsoft Access VBA, InStr function, case-sensitive search, case-insensitive search, default Binary, regional settings, Option Explicit, legacy compatibility, database sorting, ASCII values, international sorting, email lookup, TechHelp video, Richard Rost