Calculated unbound text box - format date to show mmdd



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]

Douglas J. Steele

Hmm. When I set the field's Format property to mmdd, it shows as 0501 to me.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question