Access Does not recognize " as a valid field name or expression

[MomO3]

Hi,
I have a report that I've been running for months without a problem. All of
a sudden it receives the following message, "The Microsoft Access Database
Engine does not recognize " as a valid field name or expression." It's the
that lone " mark that has me stumped. The crosstab query the report is based
off runs without error every time. It's got one parameter defined as a
date/time field. There are no quote marks anywhere in my report. Oddly, I
used to be able to make the report run by going into design mode, bascially
doing nothing, then trying again. However, this work around is no longer
working. Does anyone have any ideas?

Many thanks!
Nancy

 

[Bill]

Nancy,
Did you inadvertently get caught in the old Access
report problem of field references in code that don't
also have a control reference somewhere within the
report's design? If your report has been running in
the past, that's not likely the cause. However, when
the underlying control source works fine independently
but "seemingly" fails in use, that's a classic symptom
of the phantom field reference.
Bill

 

[MomO3]

Thanks Bill!

You got me thinking in the right direction. My report had referenced some
values in the crosstab query directly (yes, poor design). Those values had
changed, thus the illusion of a non-existent field.

Your help is very much appreciated!!!!
Nancy

 

[Bill]

You're welcome. Glad to help.
Bill

Thanks Bill!

You got me thinking in the right direction. My report had referenced some
values in the crosstab query directly (yes, poor design). Those values had
changed, thus the illusion of a non-existent field.

Your help is very much appreciated!!!!
Nancy