property is too long JohnE 12/23/2008 7:56:22 PM I have a situation in running a report. I go thru a listbox and select all the locations (100+). I go thru a second listbox and select all the accts (30+). This is actually building a where clause. This all worked last year at year end but this year there are more locations and accts. As the report begins to run, I get the following message; "The setting for this property is too long." Not sure what this is referring to or how to correct it. Is there a limitation that I should know about? How is this corrected? Thanks... John

Re: property is too long Marshall Barton <marshbarton[ at ]wowway.com> 12/23/2008 10:34:23 PM JohnE wrote: [Quoted Text] >I have a situation in running a report. I go thru a listbox and select all >the locations (100+). I go thru a second listbox and select all the accts >(30+). This is actually building a where clause. This all worked last year >at year end but this year there are more locations and accts. > >As the report begins to run, I get the following message; > >"The setting for this property is too long." > >Not sure what this is referring to or how to correct it. >Is there a limitation that I should know about? >How is this corrected? Use a shorter where clause. We can't see your code unless you post it here so can not determine which property is being used. There may be a different way to do what you wanr. For example, use an "All" item instead of selecting every item in the list, or maybe use the IN operator or ??? Once we can see the code, maybe someone will get an idea. -- Marsh MVP [MS Access]

Re: property is too long "Paul Shapiro" <paul[ at ]hideme.broadwayData.com> 12/24/2008 5:06:54 PM When I build a Where clause from a multi-select listbox, I include code that omits any filtering if either no rows are selected in the listbox or all the rows are selected. This wouldn't help if all but 1 rows are selected, but at least in my case that doesn't happen. It's either a few rows or all rows. "JohnE" <JohnE[ at ]discussions.microsoft.com> wrote in message news:1858FF1C-CD62-4886-A382-A2B4B656EC4E[ at ]microsoft.com... [Quoted Text] >I have a situation in running a report. I go thru a listbox and select all > the locations (100+). I go thru a second listbox and select all the accts > (30+). This is actually building a where clause. This all worked last > year > at year end but this year there are more locations and accts. > > As the report begins to run, I get the following message; > > "The setting for this property is too long." > > Not sure what this is referring to or how to correct it. > Is there a limitation that I should know about? > How is this corrected?