Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Runtime Error 2055 - what the heck?

Status
Not open for further replies.

pullingteeth

Programmer
Sep 26, 2003
128
US
I am getting the following error:

Runtime Error 2055 The expression '|' you entered is invalid

The code in question is attempting to msgbox a text field on a report, in the report_activate event procedure. The code works when the report is opened from the database window, but not when it is opened from a form with a where condition. What does this error mean, and how should I alter it?

Thanks
 
I solved this through trial and error. It was happening when there was no data in the report; and my no data event procedure (which closes the report) was not being triggered because it wasn't registered in the event procedures, since I had copied & pasted it into the code. Now it works, because the no data event procedure is triggered before the report activate event procedure, thus preventing meltdown.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top