GET ONFORMAT @ EVENT PROPERTY ERROR

[AUDREY @ SIG]

MY REPORT IN ACCESS 20007 RUNS AND IS VISIBLE ON SCREEN. WHEN I TRY TO PRINT
THE REPORT I GET "THE EXPRESSION ON FORMAT AT EVENT PROPERTY PRODUCED AN
ERROR "DIVISION BY ZERO". BUT I AM NOT DIVIDING ANYWHERE IN THE REPORT.
WHEN YOU ASK FOR FURTHER DETAIL ON THE ERROR IT SAYS THE OPEN PROPERTY IS SET
TO A FIELD. PLEASE HELP.

 

[Evi]

MY REPORT IN ACCESS 20007 RUNS AND IS VISIBLE ON SCREEN. WHEN I TRY TO PRINT
THE REPORT I GET "THE EXPRESSION ON FORMAT AT EVENT PROPERTY PRODUCED AN
ERROR "DIVISION BY ZERO". BUT I AM NOT DIVIDING ANYWHERE IN THE REPORT.
WHEN YOU ASK FOR FURTHER DETAIL ON THE ERROR IT SAYS THE OPEN PROPERTY IS SET
TO A FIELD. PLEASE HELP.

Hi Audrey. Go into Design View in the report. Click on the Code button the
toolbar. Paste everything in that page into your reply.

Next, ensuring that you have clicked in the area around the report, rather
than on any part of the report, click the Properties Button on the toolbar.
Click on the Event tab and Copy (by pressing Ctrl + C) and paste everything
it says next to OnOpen and also next to On Activate.

Next have a look in your report and see if there is a text box which has a
sum in it that Divides something.

Finally, look at all the field names in your tables. Are any of them a
Function in Access? eg a field called Date. I got caught once by calling a
field Eval. Everything worked fine, even a report created on the table, but
as soon as I tried to use Sorting in the report I got a Data Type Mismatch
error.

Evi