Report group on format fails

[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.

 

[Allen Browne]

Several things can cause this issue.

Make sure you don't have a missing library reference:
http://allenbrowne.com/ser-38.html

Make sure the code compiles: Compiles on Debug menu (in code window.)

If you have multiple versions of Access, it may be a persmissions issue:
http://allenbrowne.com/bug-17.html

Try a compact, decompile, compact sequence:
http://allenbrowne.com/recover.html

If you do actually have an ActiveX control on the report, try removing it.

 

[Stan the Man]

I did all of this and when I add the on format function to a group. I get
the same error.

 

[Allen Browne]

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.