Hi,

I am using Access 2002 and while designing a report I am using the inbuilt function Right() for a text box. It is working fine in Access 2002. But in Access 2000 it gives the
following error.

Microsoft Jet Database Engine does not recognize "Right " as a valid field name or expression.

Can anyone help me how to resolve this issue.

Look at your references.

You will need to refresh these for the 2000 version. To do this, remove a reference and then add it back again.

Hi Travis,

I am not getting what you are referring to ? Can you please elaborate on this ?

When you are view a Module or the Code (class module behind a report or form) unter the Tools menu there is a Reference option. This option shows a list of DLL/OCX's used by the current Access Database. What has happened is that during the conversion your references are out of sync. Remove any reference that you currently have. Exit out and then go back in and add that reference back in. This will refresh the Broken reference.