SELECT CASE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DS - 31 Aug 2006 14:55 GMT

How many Select Case's can you have before the whole thing starts
getting funky? 10? 20? 30?
Thanks
DS

Reply to this Message

Dirk Goldgar - 31 Aug 2006 15:09 GMT

> How many Select Case's can you have before the whole thing starts
> getting funky? 10? 20? 30?

I don't know if there's a limit. I know I've never reached it. Feel
free to set up a test to see if you can identify a limit. However, I
suggest that if you're writing a procedure where you fear you may run
into a limit, you may not be going about your coding in the most
efficient way. You may be able to factor out common elements of the
code and handle the process by passing some value to a parameterized
procedure.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

DS - 31 Aug 2006 15:23 GMT

>>How many Select Case's can you have before the whole thing starts
>>getting funky? 10? 20? 30?
[quoted text clipped - 6 lines]
> code and handle the process by passing some value to a parameterized
> procedure.

Thanks Dirk,
Well I ran a test on 25 and it worked fine. But I figure I'll just make
3 seperate forms, which will give me 3 Select Case's of 13, 12, and 4.
This way I don't have to go to deep into the code! I'm just trying to
re-use as many forms as possible since I've noticed that I have forms
that are used again just because of a line or two of code. So I think
less is more and more is less :)
Thanks Dirk,
DS

Reply to this Message