True, bad habits die hard i guess!

Cheers for that

Cheers Karl

There is some logic for UK VAT numbers (which I only found out today) , its detailed here:

http://www.vatliaison.com/vatinfo/vat_registration.html

Basically the purpose is to look at historic data and highlight any invalid formats to the client, where if required they can place any necessary controls to prevent invalid VAT...

works like this... 

http://www.vatliaison.com/vatinfo/vat_registration.html

just wondering if anybody out there has written code to do it already

Excellent.  Thanks!

Thanks, the loop works properly now, but I can't seem to get the field to update correctly.... any ideas please??

I need to the results like:

MATCH Supplier Name: