From the course: Access 2019: Forms and Reports

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Edit the display of a combo box

Edit the display of a combo box

From the course: Access 2019: Forms and Reports

Start my 1-month free trial

Edit the display of a combo box

“

- [Instructor] Right now, our combo box is displaying details about our product spread across three different columns. The item name, size, and color columns are all simultaneously being shown in the dropdown menu. Now I can actually clean up the display of our combo box by modifying that query a little bit. Let's go back over here to the data tab, and then the row source property, I'll click there, and then click on the build button to go back into query itself. Then, I'm going to turn off the item, size, and color columns by unchecking their boxes. Next, I'll come over here to the next blank column, and, in the field row, I'll right-click and enter in the zoom window. I'm going to change my font size up a little bit, so we can see what I'm about to type here. And here, I'm going to enter in a calculation that'll combine the item, size, and color into a single column. To do that, I'll type in a square bracket and make reference to the item field, then I'll use the text concatenation…

Contents