Brad Marks
BradM at blackforestltd.com
Thu Jan 9 08:06:54 CST 2014
Charlotte and Paul, Thanks for your insights. You confirmed what I was seeing. I appreciate your help. I have developed a work-around to the problem that I ran into. The really strange thing about this problem is that I did not receive any error message. I just happened to notice that the last argument in the string of Switch arguments was not working properly. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland Sent: Wednesday, January 08, 2014 11:07 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Switch Function - Max Argument Length? 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=AA82628C36.94FD9