Paul Hartland
paul.hartland at googlemail.com
Wed Jan 8 23:06:32 CST 2014
Brad, If I am assuming correctly and the switch function is being used to return a value in a field in a query (sorry but I don't know the technical terms) I think there is a maximum character length of about 1024 characters, if you have less characters then the problem may be to do with nested conditions/queries I think that limit is about 50. Hope this helps. Paul On 8 January 2014 20:35, 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 > -- Paul Hartland paul.hartland at googlemail.com