Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250

    Angry 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?

    TIA

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    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!!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •