Unanswered: Need a looong filter > 255 characters for form
I build a long filter and when I set the form equal to my long filter I get the following error: "The setting for this property is too long. You can enter up to either 255 or 2,048 characters for this property, depending onthe data type." My filter variable, strSQL, is declared as STRING.
I tried to make my var a dbMemo, but no dice. How do I make the 2048 active for the form filter?
I figured it out. First I tried to declare myFilter as string * 2048, but got the following error: Compile error: Constants, fixed-length strings, arrays, and Declare statements not allowed as Public members of object modules. Yes, because it was declared as Public. So, I noticed my declaration was at the end of my declarations so I decided to create a few dummy strings after my plain public declaration, so the length of myFilter (255) was expanded by 255 for each unused dummy string declaration. It solved my original error and works well!!!!!