Error 2465 with Year Function

[MIG]

I had a form which used year(date) to compare an input value with the
year of today's date. This was working fine.

Now, for some reason, I am getting run-time error 2465 "Library
Catalogue database cannot find the field 'year' referred to in your
expression."

Obviously, year is not a field, it's a built-in function. I think the
error may only relate to this particular form. What can be going on
here?

[Trevor Best]

MIG wrote:

I had a form which used year(date) to compare an input value with the
year of today's date. This was working fine.

Now, for some reason, I am getting run-time error 2465 "Library
Catalogue database cannot find the field 'year' referred to in your
expression."

Obviously, year is not a field, it's a built-in function. I think the
error may only relate to this particular form. What can be going on
here?

Have you treid Format(now(),"YYYY")?

[MIG]

Trevor Best wrote:

MIG wrote:

I had a form which used year(date) to compare an input value with the
year of today's date. This was working fine.

Now, for some reason, I am getting run-time error 2465 "Library
Catalogue database cannot find the field 'year' referred to in your
expression."

Obviously, year is not a field, it's a built-in function. I think the
error may only relate to this particular form. What can be going on
here?

Have you treid Format(now(),"YYYY")?

I will try that, thanks, but I am worried about the form being
corrupted and don't know how to go about recompiling, because it worked
previously and works in other forms, I think.

[Trevor Best]

MIG wrote:

I will try that, thanks, but I am worried about the form being
corrupted and don't know how to go about recompiling, because it worked
previously and works in other forms, I think.

I would check that form that it hasn't got anything else referencing
just "year" or something.