Report group on format fails

  • Thread starter Thread starter Stan the Man
  • Start date Start date
S

Stan the Man

I have a report with two groups. If I add an on format function to a group I
get an error even if the funtion contains on code. I receive the following
error message: The expression On Format you entered as the event property
setting produced the following error: A problem occured while Microsoft
Office Access was communicating with the OLE server or ActiveX Control.
 
I did all of this and when I add the on format function to a group. I get
the same error.
 
If you went through the recover sequence, and the problem is still there,
you might want to:

1. Cut the code from the report, and save with Notepad.

2. Set the report's HasModule property to No. Save. Compact the database.

3. Use SaveAsText to make an external copy of the report (as linked at the
end of the recovery article.)

4. Delete the report. Compact again.

5. Verify that the database doesn't still have the problem anywhere.

6. Import the report using LoadFromText. Verify the problem does not exist.

7. Copy the code in from Notepad into the report's module.

If the problem as absent all the way to step 7 and then returns, the code is
faulty.
 
Back
Top