Access doesn't recognize "Date" or "Right" (Access 2007, Windows XP OS)

[spqapat]

Reports and subreports that have worked well for years recently began asking for parameters when encountering text boxes that involve either Date() or Right. E.g.,

=IIf([stepdue]<Date() And [stepdone]=False,"Overdue","")

=Right([txtgoalnumber],1)

I replaced "Date()" with "Now()" and removed "Right"--and no longer get errors.

What might be the cause of the problem?

[WendellB]

More often than not, that sort of error indicates you have a missing reference in your VBA project. You can check that by opening any module, or form that has code behind it, and doing Tools\References in the VBA editor. If you see something that says "MISSING - ..." that's the clue. Resolving a missing reference is usually a matter of locating the file on your system. Another possibility is that you have somehow created functions that are named Date and Right - but that seems rather remote.

You should also be aware that using Now() rather than Date() will give you different results if the [stepdue] value is equal to the current date

[spqapat]

I checked References, did not see anything MISSING. Could my workstation copy of Access be corrupt? Any other ideas I could pursue?

[patt]

If you are able to, produce a cut down version of your database, compact it, then zip it and make it available here. We can then see if the database is wonky or not.