Re: Can't print most reports....

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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


"Ucando262" <u48808@uwe> wrote in message news:9016a9e3adb50@xxxxxx
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....



.



Relevant Pages

  • Re: 2007 wants to repair 2000 format database
    ... 2007 opens the database but when a report is run, ... the open event of the report. ... compact & repair have all been done to no avail. ...
    (microsoft.public.access.formscoding)
  • Re: Compacting messed me up?
    ... > Then I saved that test form as a REPORT. ... The report starts with record_ID 51!!! ... >>> It seems like after I did a compact and repair, ...
    (microsoft.public.access.formscoding)
  • Re: Access has encounterd a problem
    ... The record source for the report is a table. ... They include creating a new .mdb and copying ... So keep an eye on the size and compact and repair ...
    (microsoft.public.access.reports)
  • Re: Compacting messed me up?
    ... Then I saved that test form as a REPORT. ... >> It seems like after I did a compact and repair, ...
    (microsoft.public.access.formscoding)
  • Re: Cant do anything with reports
    ... repair and compact your database. ... Check if you can run any report when disabling a virus scanner. ... Take such a non-working database and test it on your working PCs. ...
    (microsoft.public.access.reports)