Formatting Cardinal Dates

Here's a neat one on cardinal dates. Cardinal numbers, you'll remember from school, are the "st's and th's", for example 1st and 2nd and 103rd. This article includes a function for 1st January 2008 that could easily e cumstomized for a variations like January 1st 2008.

The Format() Function

The VBA format() function should be an important part of your Access/VBA toolbox. It lets you convert numbers or dates to strings, specifying exactly the formatting you want.
The format() function can help answer such questions as

How do I make my numbers show with leading zeroes?

How do I get the month name instead of the month number in my dates?

This article from UtterAccess.com is one poster's attempt to bring together a bunch of different pieces of information on format(). The writer has found that Microsoft has distributed the various references you need to be able to use format() throughout the help system, and so has collected it into one document.