Wierd Ucase error

[Soma_rich]

I have a field that I want always be stored in Upper case so use the Ucase$ function:

Forms![CyclicJobInput].JobName = UCase$(Forms![CyclicJobInput].JobName)

It works fine on an XP machine but on a Win2K machine it errors saying it cant find the function. Although I can see it in the VB object browser on the users machine.

Any ideas?

 

[RuralGuy]

Have you checked to see if you have any Access Reference Problems in the 2K system?

 

[Soma_rich]

That looks like what it was there were some missing ActiveX refrences on the users machine.
Sorted now.

No idea why it was falling over on Ucase

 

[RuralGuy]

Any "Missing" reference error causes the problem you described. Have a good one!