ACC: Error Using More Than 2000 Characters in WhereCondition of OpenReport

MORE INFORMATION

Steps to Reproduce Problem

1. Start Microsoft Access and open the sample database Northwind.mdb.
2. Use the AutoReport: Columnar wizard to create a new report based on the Shippers table. Save the report as rptWhereTest.
3. Create a new module, and type or paste the following procedure into the Module window:
   

         Sub ReportWhereTest()
   
            Dim strPWhr As String
   
            ' Build a Where clause that is 2046 characters long.
            strPWhr = "[Phone] in ('" & String(2031, "a") & "')"
   
            ' Show how long the WhereCondition is.
            MsgBox Len(strPWhr) & " Characters"
   
            ' Open the report with the WhereCondition.
            DoCmd.OpenReport "rptWhereTest", acViewPreview, , strPWhr
   
            ' If you are using Microsoft Access 7.0, comment out the
            ' previous line that contains the OpenReport method by typing
            ' an apostrophe at the beginning of that line. Then remove
            ' the apostrophe from the beginning of the following line:
            ' DoCmd.OpenReport "rptWhereTest", acPreview, , strPWhr
   
         End Sub
   						

4. Compile and save the code.
5. Run the procedure.
   
   Note that the code fails silently or that you receive one of the error messages described in the "Symptoms" section of this article.