How can I put 50 Toggle Buttons of a Group Option on a small form???

[jokelogpop]

How can I put 50 Toggle Buttons of a Group Option on a small form???
This is my question for all. I have 50 options for my users and all of them must be put on a form. how can I do that?? I know the List box is the suitable choice but I want Buttons instead of texts like ListBox.
I expect your guide!!
Thanks so much!!

 

[WayneRyan]

j,

How about multiple option groups. You're limited to 20 within each
group ... so three groups? Each group could default to a choice meaning
none of the above.

If you go to "individual" controls (unbound probably), you are going to:

a) name them so that you can access them programmatically (Check1, Check2 ...)
b) write a LOT of code to make them mutually exclusive, clear them afterwards ...
c) use a "master" command button so that you don't have to code an event for
each checkbox.

Just some thoughts,
Wayne

 

[jokelogpop]

Hi!
I think I may put 50 pictures like 50 buttons in a List Box??
How do you think about this idea?
Can I do that??

 

[smercer]

I had put some pictures in on my buttons, and the first thing I noticed was that the database became unstable the more buttons I had done. (Office XP, I am now using Office 2003 so I do not know yet if it is still the same)

Now that all the code that were in the buttons are now via function key shortcuts it is much faster and more stable.

If you think I didn't have the memory for the set up I had, think again. 1Gb is more then enough to run anything I please.

And no you can not have pictures in a list box