Custom List Box Columns in Microsoft Access. Dynamically Display Fields Based on User Selection.

[@renjithvijayakumar9022]

The way you are explaining to us is so much interested... Thank you for your classes 🙏

[@599CD]

Thanks and welcome

[@josecandidosorianavalon3339]

Superb performance of using sql and controls properties... Thank you and congratulations.

[@599CD]

Welcome. Glad you enjoyed.

[@peterl2616]

Richard, you are a beast. Love the tricks and shortcuts as always. You rock. Thank you.

[@599CD]

BEAST MODE ACTIVE! :)

[@adelabdelhamid8272]

Really , Unique idea , Unique illustrated lesson , thanks a lot , much respect from Egypt

[@599CD]

Glad you liked it!

[@hassanrozh6579]

Great idea, thanks so much.

[@599CD]

You are so welcome!

[@simplelivingisfun7646]

this is for column values, can i use this for row values? what parameter should i change? thanks in advance

[@599CD]

599cd.com/Ask

[@elijahhayes8833]

If one of the columns was a currency field, is there a way to format it in the list box?

[@afrinsir7479]

is it possible in reports same as it ?

[@josemariaroman7057]

Is it possible just to modify the ColumnWdth property with a 0 or non 0 value depending on the state of the corresponding checkbox? This way all columns are there, but you don't see all of them, and do not have to modify the RecordSource. Or would there be any unforeseen problem?

[@599CD]

That would work as well. I don't foresee any problems.

[@achimmarliani2949]

Hi Richard, just a short remark: as it comes to adding OnClick events to all the checkboxes you state that there is no easier way to do this. In fact there IS an other and sometimes easier way (and I assume you also know it). That is to in the event properties list add the line "=RequeryList()" to all the OnClick-events instead of adding multiple event handlers, one for each checkbox. But this requires the RequeryList function to be a public function, and I agree that this might be out of scope of even a intermediate level lesson. But all in all, I love to watch your videos, in each of them I find some gems I did'nt know oder understand correctly until.

[@599CD]

You're mostly correct, Achim. That is definitely quicker than making a unique event handler for each checkbox. I say "mostly" correct because RequeryList doesn't need to be a PUBLIC function. It can still be a private function in that form's module. You do need to make it a function though, even though it doesn't have to return a value. But this would make a cool advanced trick to show people. Thanks for the reminder (I haven't used this technique myself in years). I'll put it in an upcoming Fast Tips video. Hmm... maybe tonight's. :) You are also correct that I try not to put TOO MUCH information in a single video. I don't want to blow peoples' brains. LOL.

[@599CD]

Just made this the topic of tonight's video. Posting it now. Enjoy! :)

[@achimmarliani2949]

@@599CD :))) Thanks!

[@jacksonmacd]

Along the same lines, it would be badly simpler to use a store the display width in the Tag property of each checkbox. Then use a constant record source and control each columns width using the value from the Tag property.

[@tewwonwonii8462]

Excellent.

[@599CD]

Many thanks!

[@DingusBatus]

Instead of a bunch of IF statements could it be done with Select Case? Select Case Control.Name. It wouldn’t really shorten the code any, and I don’t know about performance difference, which would be faster, but it “might” look tidier? Certainly a bit more show off like?🤔😜

[@afrinsir7479]

awesome please make video on advance vba examples

[@599CD]

I've got 37 levels of Developer classes: 599cd.com/Developer

[@syedabbas201]

Nice👍👍

[@599CD]

Thanks

[@abdulhamidalhaddadi2255]

Great

[@599CD]

Thanks