Can't print most reports....

[Ucando262]

I am fairly experienced with Access 2003. However in the process of updating
to 2007 I constantly get an error after I create a report and try to print it.
It says "The expression ON FORMAT you entered as the event property setting
produced a type mismatch error" Can any one help me. Most of the reports I am
creating I am not touching the properties. When this happens I have been
deleting everything and starting all over and most of the time the report
will run. However, it is very frustrating.. Thanks....

 

[Jeff Boyce]

Did you compile the database (.mdb file) prior to updating to 2007?

Did you (save a copy and) run Compact & Repair before updating to 2007?

Have you tried re-compiling in 2007?

Have you tried (saving a copy and) running Compact and Repair in 2007?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Michael J. Strickland]

I've seen that error before and usually it was caused by incorrect or
missing
references. 2003 and 2007 have different defaults (e.g. for DAO vs ADO)
so
check that your references are intact (in Code View: Tools->
References).

Did you compile the database (.mdb file) prior to updating to 2007?

Did you (save a copy and) run Compact & Repair before updating to
2007?

Have you tried re-compiling in 2007?

Have you tried (saving a copy and) running Compact and Repair in 2007?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

--