Denver Area Access Users Group

Have you ever wanted to allow the user to change the columns that are displayed on a form? Sometimes you might want to see a customer's phone number. Other times you want to see their address. You may not want to make a giant form with everything on it, and you don't want to have to make lots of different forms.

Join us as Richard Rost shows how to select which fields are displayed in the columns of a list box based on the user selection. You'll see how to do it first the "easy" way using checkboxes to represent the different fields. He'll also show a more advanced technique to 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.

Richard Rost is the owner of Computer Learning Zone, a technology education firm based in Florida. Richard has been teaching software courses since 1994, and was an Access MVP in 2014 and 2015. He has an extensive online library of Access training videos at his YouTube channel at https://www.youtube.com/599cd.

Watch the recorded video of Custom List Box Columns on our YouTube channel