Calculated unbound text box - format date to show mmdd

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

I have an unbound text box on a form that i want to display mmdd of the
"Date Earned" Text box.

It works, but if the date is 05/01/2009, then it only displays 51.

How do I make it read 0501?

It is populated through a setvalue macro - OnExit property of "Date Earned".

Thanks in advance:)
 
I just relized that someone else posts under the name "Kay" and the other kay
([email protected]) is not very nice. Please, before any one assumes I am
this person please verify the profile address.

I love this site and am certainly not "going to bite the hand that feeds me".

Thanks so much every one for being there when I have issues with my database.

my email:[email protected]
 
Hmm. When I set the field's Format property to mmdd, it shows as 0501 to me.
 
Back
Top