Date format Answer

[sparkle_guy]

Thanks to Paul Hollis for his reply. For anyone in the UK who wants to use
dates in a text box in the format DD/MM/YYYY you can do it this way.

Make sure that the date format is set to DD/MM/YYYY in Control
Panel/Regional Settings/Regional options

the command Date() will give the date in this format its just when it is
displayed it is shown as MM/DD/YYYY

However mytextbox.value = cstr(date()) will show the date as DD/MM/YYYY in
the text box when the form runs.

If you need to do calculations with the date you can use the datevalue
function

Hope this is of use

Paul