« How to unlock a access 2003 database?
When I access AIM on my cell phone, does it require internet? If not, what does it count as? »

In Microsoft Access 2003, how do you display 4 digits of a year using Date/Time format in the field?

I’m a very newbie in all of this Access stuff! I think I didn’t phrase my question correctly either :P anyway, I want my record in my table to display 4 digits in a year using Date/Time format. How do I do that exactly, in design view? :s If you could provide a step-by-step guide i’d be eternally grateful! :D

Down in the field properties section, on the format line type:

mmm dd yyyy

And this will make it appear as Mar 14 2009

or type

dd mmm yyyy

And this will be 14 Mar 2009

Point being, yyyy is what makes full year.

you do the same formatting technique in your form when you create the forms.

This entry was posted on Wednesday, November 25th, 2009 at 3:16 am and is filed under microsoft access 2003. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “In Microsoft Access 2003, how do you display 4 digits of a year using Date/Time format in the field?”

  1. brayden Says:
    November 25th, 2009 at 8:57 am

    Down in the field properties section, on the format line type:

    mmm dd yyyy

    And this will make it appear as Mar 14 2009

    or type

    dd mmm yyyy

    And this will be 14 Mar 2009

    Point being, yyyy is what makes full year.

    you do the same formatting technique in your form when you create the forms.
    References :

Leave a Reply