Custom data validation??

Hi All,

I have an issue that i cannot solve using my small brain!!

I have attached a sheet, which probably makes more sense.

What i need to do is make sure users enter their domain\username and NOT just their username.

I want it to not let them enter anything unless it has the domain, UK\, infront of their username. Their username could be any length.

e.g. UK\jsmith is a valid entry, just jsmith is not

Hence the reason why i went down the custom data validation route (but any other solutions would be greatly appreciated.

I would just re-design the form personally but as i have just come onto a project late on there is no chance they will do this

Anyway, thanks for your help in advance!!

JBeaucaire, you are a genius!! It works a treat!

And don't let anybody else tell you otherwise...