[AccessD] Switch Function - Max Argument Length?

Brad Marks BradM at blackforestltd.com
Wed Jan 8 14:35:24 CST 2014


All, 

I have an Access 2007 application that has a query with a Switch
Function that has a very long set of arguments.

I recently needed to add one more "expression/value" and discovered that
the newly added expression did not work.

It appears that there is some sort of limit as to how long the set of
arguments can be.  I have done some digging, but have not been able to
find this limit documented anywhere.

Is there such a limit?

Thanks,
Brad  



More information about the AccessD mailing list