Date Format Not Copying Back Correctly Onto Userform

Hi All

I have a userform that copies data across to my database. I have a search function which enables me to bring back the data so I can edit as neccesary.

The problem i am having is that the data format is in UK on my database, and is exactly as i enter it (DD/MM/YYYY). However when i search & bring the data back to my userform it converts it to the US date style (MM/DD/YYYY).

Can anyone help, i have attached the code below for my search function.

Thanks
Mark

Please Login or Register  to view this content.

Does this work?

Please Login or Register  to view this content.

Dom

You could also use:

Please Login or Register  to view this content.

Dom