By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,459 Members | 2,284 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,459 IT Pros & Developers. It's quick & easy.

Format Unbound Txt Box for Date

100+
P: 135
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?
Dec 27 '08 #1
Share this Question
Share on Google+
2 Replies


100+
P: 135
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...
Dec 27 '08 #2

NeoPa
Expert Mod 15k+
P: 31,398
Expand|Select|Wrap|Line Numbers
  1. =Day([Forms]![TimeCard]![Week2Start])
would also be viable.
Feb 16 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.