Change textbox format to date

Hi guys

I have this code

Please Login or Register  to view this content.

My question is, how do i change the date format of the textbox to dd/mm/yyyy? because when i type the date 5/10/2012 in the textbox, it will appear 20/5/2012 in the database.

Thank you.

use format(Me.textbox3.Value,"dd/mm/yyyy")

Hi Sindhus

Thanks for your reply but when i put the code that u give, it doesnt function. Its shows compile error.

can you attach your workbook?

Hi Sindhus

I already attach a simple dummy file. Whenever i put the date in the format dd/mm/yyyy in the textboxt, it will appear in the database in format mm/dd/yyyy. Hope you can help me. Thank you

You can format the D column to DD/MM/YYYY format before running the code. Or try this code.

Please Login or Register  to view this content.

You can use either DateValue or CDate:

Please Login or Register  to view this content.

Hi Sindhus and Norie. Thanks a lot! both of your codes can be used!