Show different date format in message box in access

[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

Here is my code, but I think I am doing somthing wrong

I have tried both of this, but no luck

Private Sub Save_Click()
Dim LValue As String
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

Private Sub Save_Click()
Dim LValue As String
LValue = Format(Date, "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

[alansidman]

With your form open in design view. Place your cursor on the text box you wish to format. Right Click and select Properties. Click on the Format tab. Scroll down to Font Weight and select Bold. Close the Properties and save the form. Reopen in Form view.

[hendrikbez]

With your form open in design view. Place your cursor on the text box you wish to format. Right Click and select Properties. Click on the Format tab. Scroll down to Font Weight and select Bold. Close the Properties and save the form. Reopen in Form view.

No that is not what I want, I want my message box to show my date as 27/01/2014 but it is showing 01/27/2014, I need the date format to change, I only make the date bold, to show what I want the date to look like.

Sorry if I have confused you

[amrut]

You can format the date in any form to display. Replace the Date() in the expression with your date field.
Ex: Format (Date(),"dd mmmm,yyyy") : 07 January,2015
Format (date(),"dd/mm/yyyy") : 7/01/2015
Format (date(),"dd/mm/yy") : 07/01/15
Format (date(),"ddd mmm dd,yyyy") : Wed Jan 07,2015
I don't think you can format the messagebox to display font in bold. This link shows a different approach for enhancing controls on message box, not sure if it will help you.
http://blog.nkadesign.com/2008/ms-ac...x-replacement/

[hendrikbez]

Thank You, I have got it to work

[alansidman]

I am glad you got what you wanted, but here is what you asked for

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.

Clearly you need to pay close attention to what you request.

[hendrikbez]

I am glad you got what you wanted, but here is what you asked for

Clearly you need to pay close attention to what you request.

I did get what I was looking for, I did not need it to be bold, I only make it bold to show the difference of the date, that I want to have, sorry for the confusing I have make here.