StrConv function undefined

[rogerte]

We have recently changed from Office2003 to Office 2007

Generally most Access 2003 mdbs open fine, but in a couple (used for label production) there are (non VBA) queries that includes formulae that uses the StrConv function.

As an example the simplest of these is:
FullName: StrConv(Trim([forename])+" "+[surname],3)

Whenever these are run we get an "Unidentified function "StrConv" in expression" error.

Tried converting from MDB to ACCDB but got same error, so rebuilt the expression using the expression builder, but, even though StrConv is there, still get same result.

Have checked the Microsoft Access 12.0 Object Library is checked in the VBA\Tools\References dialog.

I assume it must be a settings error.

Can anyone give me a clue as to the reason it is happening?

Thanks

Roger

 

[dhookom]

StrConv() works in Access 2007. I expect you might have another reference that is missing. It doesn't have to be any specific reference. You might also get this error if you have defined your own StrConv function or have named a module StrConv.

Duane
Hook'D on Access
MS Access MVP

 

[rogerte]

Don't think so.

I have created a sinple database consisting of one table that has 2 columns: Foename and Surname.

Then I created a simple query that includes those 2 columns plus the FullName: StrConv(Trim([forename])+" "+[surname],3)

Tried running the query and got same result.

Cheers

Roger

 

[dhookom]

Open any module and review all the checked references. Maybe add a little code and attempt to compile. Also try some other functions like Left() or Right() or Mid().

Duane
Hook'D on Access
MS Access MVP

 

[rogerte]

I set up a blank database, then imported all the tables, queries and forms from the old database, and it all runs ok.

Have checked the "ticked" references and they appear to be identical.

The 2 databases now appear identical in every respect, except the old one throws the error!

Guess I'll put it down to experience.