Show date in messagebox

[hendrikbez]

I have a messagebox and want to know if it is possible that the messagebox give me a date as 15/01/2015 and not 15/01/2015. Using dailog box as messagebox

Private Sub Save_Click()
Dialog.Box "Tape #                : " & Me.Tape & vbCrLf & "Sticker #             : " & Me.Container1 & vbCrLf & "Book #                : " & Me.Book & vbCrLf & "Date send Out    : " & Me.DateSendOut & vbCrLf & "Date to be back  : " & Me.DateToBeBack & vbCrLf & "OS                       : " & Me.System, , "Saving............."
 End Sub

 

[spikepl]

So you want date as 15/01/2015 or as 15/01/2015?

 

[pr2-eugin]

I have a messagebox and want to know if it is possible that the messagebox give me a date as 15/01/2015 and not 15/01/2015.

Sorry I fail to see the difference between 15/01/2015 and 15/01/2015

 

[hendrikbez]

I want it to be 15/01/2015 or it will be better if it can show 15 Januarie 2015.

 

[pr2-eugin]

Did you have a look at Format Function?

http://www.techonthenet.com/access/functions/date/format.php

 

[hendrikbez]

Thank you I did read it, but I still do not understand to get it to work. Here are my code, I have tried tow ways, but no luck..

Private Sub Save_Click()
Dim LValue As String
LValue = Format(Date, "dd/mm/yyyy")
LValue = Format(DateSendOut, "dd/mm/yyyy")
Dialog.Box "Tape #                : " & Me.Tape & vbCrLf & "Sticker #             : " & Me.Container1 & vbCrLf & "Book #                : " & Me.Book & vbCrLf & "Date send Out    : " & Me.DateSendOut & vbCrLf & "Date to be back  : " & Me.DateToBeBack & vbCrLf & "OS                       : " & Me.System, , "Saving............."
end sub