You can format the date using the below function...

Format(Date, "dd/mm/yyyy")

i.e. Format (DateBox.Text,"dd/mm/yyyy")