Formatting Date in a Form

[DebbieV]

Hi All,

I have a form that will display the date that was entered in a text box on the switchboard. It reads: = "Mail Received on: "& Forms!switchboard.txtMailDate. I want it to be formatted so it displays the day of the week, date and year but I don't know where to insert this format ("ddd mmmm dd, yyyy") in the current control source as it is now to display as asked.

Your help is most appreciated.

DebbieV

 

[boblarson]

In the FORMAT property of the text box you can use:

ddd mmmm dd", "yyyy

 

[DebbieV]

Yes, I did try that, but the date continues to display in numbers only like 09/28/2009.

 

[MSAccessRookie]

Hi All,

I have a form that will display the date that was entered in a text box on the switchboard. It reads: = "Mail Received on: "& Forms!switchboard.txtMailDate. I want it to be formatted so it displays the day of the week, date and year but I don't know where to insert this format ("ddd mmmm dd, yyyy") in the current control source as it is now to display as asked.

Your help is most appreciated.

DebbieV

In the Properties for txtMailDate, there is a Format Property that allows you to define the way that the date will be displayed. If that does not work, you can use probably the Access Format() command to format the date the way that you want.

NOTE: Looks like Bob Larson is already on this one. Don't forget to play around with the Format() command to see if you can format the date the way that you want.

 

[DebbieV]

Yes, that is where I entered it. If I use the format property, I am not sure how to arrange the syntax, I tried putting format after dot before txtmailDate but I got an error.

 

[boblarson]

Yes, that is where I entered it. If I use the format property, I am not sure how to arrange the syntax, I tried putting format after dot before txtmailDate but I got an error.

I goofed - instead of the format property just use this:

= "Mail Received on: " & Format(Forms!switchboard.txtMailDate, "ddd mmmm dd, yyyy")

 

[DebbieV]

Thanks for your help, it works perfect now.

DebbieV