Display a date as mm/dd without the year

In a bound text box formatted as Date/Time, I want to display only the month and day, single digit where applicable.  e.g.  5/9   12/31    1/1   10/4    6/28
What is the format string, and do I set the format in the table, or in the form control?
David_W_RAsked:
Who is Participating?
 
PatHartmanCommented:
Open the property sheet for the control.  On the Format tab, set the Format property to:

m/d

If you click into the field, the full value will show.
0
 
Rey Obrero (Capricorn1)Commented:
In the format property of the textbox  place   m/d

no need to set the format in the table, it should remain as Date/Time data type
0
 
David_W_RAuthor Commented:
Thanks for the quick replies... initial response by Rey Obrero and added info by PatHartman
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.