I know this is going to be a simple answer but ive looked all over and can't find it.

I have developed a database that uses the replace function in a report. This works fine under test conditions using the full version of access but doesnt seem to work under runtime conditions.

A runtime error is generated saying that it does not recognise the replace function. Am I missing an add in somewhere?

Your help is much appreciated.