Strange Out of memory Run-time error 7 using instr() function

[sakurako97]

Hi,
I was wondering if anyone else has come across this Out of memory error when using instr().

My pc has heaps of physical and virtual memory, and my access dbase is quite small. I was using instr() in a browsefolders function, and it gave me the Out of Memory error.

I tried creating a new blank database with just 1 form, and the following line of code: MsgBox InStr(1, "Northwind", "r") - and I still get the same message. I am using a fully up to date version of Windows Vista Ultimate and Access 2010 beta.
I have used a bunch of other string functions with no problems, and so am at a bit of a loss as to what this might be

Any ideas would be greatly appreciated!!

[ChipR]

The same code works fine for me in Access 2007.