Channel: Computer Learning Zone

Category: Education

Tags: #tutorialread settings from table#msaccessdisplay only selected fieldspopulating a multicolumn listboxcolumn widthsms accessuser defined list box columnsmulti-select list box#microsoftaccess#howto#lesson#traininguser editablemultiple columnsmicrosoft accessspecify columns#help#database#learnms access tutorial

Description: In this Microsoft Access tutorial, I'm going to teach you how to select which fields are displayed in the columns of a list box based on the user selection. Annie from Pembroke Pines, Florida (a Platinum Member) asks: is there any way for the user to change the columns that are displayed on a form? Sometimes we want to see the customer's phone number. Other times we want to see their address. I don't want to make a giant form with everything on it, and I don't want to have to make lots of different forms. Can this be done? Silver Members and up get access to an Extended Cut of this video. Members will learn how to get rid of the check boxes. We will read the fields directly from the table properties, including which fields to display, the caption, field name, column width, and whether it should display on form load or not. MEMBERS VIDEO: youtu.be/Zj675zKk7pk BECOME A MEMBER: YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join or My Site: 599cd.com/THMember LEARN MORE: 599cd.com/CustomListBox FOLLOWUP VIDEO: 599cd.com/EventHandlerFunction LINKS: Relational Combo: 599cd.com/Relational SQL With Access: 599cd.com/SQLwithAccess Intro VBA: 599cd.com/VBA After Update: 599cd.com/AfterUpdate SUGGESTED COURSE: Multi-Select List Boxes: 599cd.com/ACD15 OTHER COURSES: FREE Access Beginner Level 1: 599cd.com/Free1 $1 Access Level 2: 599cd.com/1Dollar FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: 599cd.com/THFree Blank Template: 599cd.com/Blank Contact Management: 599cd.com/Contacts Order Entry & Invoicing: 599cd.com/Invoicing More Access Templates: 599cd.com/AccessTemplates ADDITIONAL RESOURCES: Donate to my Tip Jar: 599cd.com/TipJar Get on my Mailing List: 599cd.com/YTML Contact Me: 599cd.com/Contact TechHelp: 599cd.com/TechHelp Consulting Help: 599cd.com/DevNet Twitter: twitter.com/LearningAccess en.wikipedia.org/wiki/Microsoft_Access products.office.com/en-us/access microsoft.com/en-us/microsoft-365/blog/access KEYWORDS: microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, user defined List Box Columns, Specify Columns, User Editable, Multiple Columns, Populating a MultiColumn ListBox, column widths, multi-select list box, read settings from table, Display only Selected Fields QUESTIONS: Please feel free to post your questions or comments below. Thanks.