Error when viewing/printing

[Guest]

I have a report based on a query, where the query runs fine, but when you run
the report an error keeps on popping up multile times: "The value you entered
isn't valid for this field". I have checked all the data in the fields on
the query/report and nothing is out of the ordinary. Is there something else
that can cause this error?
Thanks

 

[Guest]

Patricia,

This is a hard one because you say nothing looks strange. Somehow Access
sees something and is telling you that something is wrong.

You could do two steps:

1. Setp into VBA on the on_open of the form to see what the action is that
Access is taking. This is only useful if you have any code behind the report.
2. Copy the report Place the same source (query or table) in the report and
then place each field step by step on the report viewing it after each
addition you have made. I know it's a time consuming solution but it will get
you to the problem of your report.

hth