date format

[enrico via AccessMonster.com]

how do you customize in vba or in your form's property a date field's format?
e.g. january 14, 2009 will only show january 2009 or 14

 

[Daniel Pineault]

It depends.

You can either look at the Format Property, but this could also be a
question of setting your computer's regional setting to the way you like.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Douglas J. Steele]

To get January 2009, set the format to mmmm yyyy.

To get Jan 2009, set the format to mmm yyyy.

To get 14, set the form to dd