Limitation - Select Case and IF THEN

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Just wondering if there is a limitation on the number of
CASE or IF-THEN statements one can have within a form's
code?
I had an application had a long chain of CASE statements.
I would paste the statements in the form. When I ran -
and attempted to get to that part of the form logic - I
would get a hault/stop, etc. - from what I recall it would
highlight something towards the top of the code window -
for the form with the CASE logic on it. I tried switching
to IF-THEN statments - but id did the same thing.

Then I noticed if I used 1/2 of the statements - it would
work. Slowly I incremented up the number of statements
and eventually if failed again.

I didn't narrow now specifically what the number was that
caused the failure - but just wondering if anyone else has
run into this problem - and what the limitation is - so
everyone knows for future reference.

thank you.
 
You might have run into a size limit on a JITted code for a single
function - it cannot be over 64K
 
Back
Top