John,

That worked a treat, thank you very much. I have had to use your code in an Access form as VB is not installed on our machines. I will pass it on to the BOFH so he can integrate it.

you the man
ben