Hello,

I was wondering if it is possible to add checkboxes in a list box.
So, is it possible? If so, how?

This is a question that has come up alot of times, in theory the answer is No. But there is a workaround that goves the impression that you can have a tick or a cross in a column. To do this you have to use a msflexgrid control. Not as easy to code but you can do it as it gives you the ability to tock in a cell in the flexgrid and get it to changes the value.

On the other side of the coin if the addition of a tick box in a list control is of paramount importance you can get OCX controls that will provide this functionality and are easy to use in Access and VB.

CodeMaster::cool:

This is a question that has come up alot of times, in theory the answer is No. But there is a workaround that goves the impression that you can have a tick or a cross in a column. To do this you have to use a msflexgrid control. Not as easy to code but you can do it as it gives you the ability to tock in a cell in the flexgrid and get it to changes the value.

On the other side of the coin if the addition of a tick box in a list control is of paramount importance you can get OCX controls that will provide this functionality and are easy to use in Access and VB.

CodeMaster::cool:

Thanks for the reply, DCrake.

I am not familiar with msflexgrid. :(

What I am trying now is adding Subform in my main form.
I tried adding checkboxes in the Subform and appears same in main form.
I can also scroll the checkbox items. Just what I need.

What I need now is adding the controls such as checkbox to the Subform.

Any ideas?

If you are using a continious subform then you should be able to use checkboxes in you sub form.

If you are using a continious subform then you should be able to use checkboxes in you sub form.

Yep, I am using a continuos Subform.
The logic is when I click a button in the Main form,
a checkbox item is added in the Subform.
It keeps loading. Is this Ok?

Is there a script that will automatically add controls to Subform?

Why not create all the checkboxes on the form, set the visibility = false and depending on what is clicked on the main form it sets the checkboxes visibility = true?

-dK

Still trying to grasp what you are displaying on you main/sub forms?

What is the purpose of the setup?

Why not create all the checkboxes on the form, set the visibility = false and depending on what is clicked on the main form it sets the checkboxes visibility = true?

-dK

I can't implement that way because the number of checkboxes are dynamic.

Here's the logic.
I search excel files from a pre-determined folder.
These files will be displayed in a list with checkboxes.
If there are lots of files in a folder, the GUI would be long
enough to scroll the whole form.

I want to scroll the list of checkboxes only.
That way, the size of the form is maintained.

That's why I came up of the list with checkboxes in it.

Is there a better way to implement this?
I am really open to your wise advices.

So you have a routine that lets the user navigate to a folder that contains Excel files? Or you have a predefined folder that the user is directed to.

From this point you have a list box that is populated with the contents of the folder with all the Excel files that exist.

What do you want to do once your list box has been populated with the Excel files?

The answer to this may result in a more constructive solution.

CodeMaster::cool: