Format Unbound Txt Box for Date

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MyWaterloo
    New Member
    • Dec 2007
    • 135

    Format Unbound Txt Box for Date

    How do I format an unbound text box to display just the "day" part of the date? Instead of 12/27/08 I want to have the txt box just show the 27. Is this easily possible?
  • MyWaterloo
    New Member
    • Dec 2007
    • 135

    #2
    Ha! I'll answer my own question... I figured it out; the correct way to format my txt box. In "Control Source" I entered:
    =Format([Forms]![TimeCard]![Week2Start],"dd")

    For Posterity...

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32661

      #3
      Code:
      =Day([Forms]![TimeCard]![Week2Start])
      would also be viable.

      Comment

      Working...