[AccessD] Switch Function - Max Argument Length?

I seem to recall that there was a maximum of something like 13
expressions/values for Switch.  If you need more than that, your query is
probably going to have trouble running anyhow.

Charlotte


On Wed, Jan 8, 2014 at 12:35 PM, Brad Marks <BradM at blackforestltd.com>wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>