CASE Statement Problems

[sherlocked]

Hello there, hoping some VBA wizard will be able to help me. I have a lengthy CASE statement in my database that displays specific text in a field based on the value of another. Simple stuff but for some reason it randomly will not work on certain values, and never the same one twice. Is there a commonly known cause for this? I have verified that the spelling and spacing etc. are correct in my code so that shouldn't be causing the problem.

Any help or thoughts are greatly appreciated as I have been agonizing over this for a day or two now! Thanks!

 

[spikepl]

Code that works works.

If it occasionally fails, that means it is being fed by data that suck. That in turn means that the data is out of the expected range, and that the code was not told how to deal with data out of range.

 

[sherlocked]

Thanks, I was able to get this to work. Turns out I had the event in the wrong OnFormat section. Cheers!