Hi all, I am tring to figure out how to format the date that is inputted using an access calendar control, what i have here works, but I would like to know how to change the format to be format(date,"ddmmyy").
Thank you all,
Private Sub CommandButton1_Click()
Dim x As Range
Set x = Application.Worksheets(1).Cells(1, 1)
x = Me.Calendar1.Value