Can you have a List Box with Formatting and Colors in Access?

I get asked this question all the time: "can you have colors and other formatting in list boxes in Microsoft Access?" In this video we'll take a look at some options that are available.

Simon from Oregon (a Silver Member) asks, "Is it possible to have formatting and colors for different rows in a standard list box?"

Members

I'll show you how to prevent users from editing our popup form. You'll also see how to colorize any field in the form based on the value of a different field.

•  Extended Cut Video - Silver
•  Database 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

Continuous Forms: https://599cd.com/Continuous
Conditional Formatting: https://599cd.com/Conditional
Format Painter: https://599cd.com/format+painter
DoCmd.OpenForm: https://599cd.com/openform
On Double Click Event: https://599cd.com/ondblclick
DoCmd.Close: https://599cd.com/docmd.close
Forms!FormName Notation: https://599cd.com/formname
Access Developer 16: https://599cd.com/acd16
Allow Deletions, Edits, Additions: https://599cd.com/allow+deletions
Navigation Buttons, Record Selectors: https://599cd.com/navigation+buttons
Conditional Format Expression: https://599cd.com/expression+is

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.