Date formats in Forms

[sparkle_guy]

I am putting the date in a text box on a form when the form opens using

mytextbox.value = date

The date shows as MM/DD/YYYY

I am working in the UK and would like the format to be DD/MM/YYYY

I have tried using mytextbox.value = CDate(date) but to this doesnt work

I have tried setting the field for the textbox as a date field formated
DD/MM/YYYY but it still doesnt work

Any ideas on how to force the text box to take the format I need

I also have a box in which the date is dispalyed when a check box is
selected so using a predefined field like sent date wouldnt work there.

Thanks in advance paul