Month
Using the MONTH Function
In this tutorial you will learn how to use the MONTH Function.
The MONTH function returns an Integer specifying a whole number between 1 and 12, inclusive, representing the month of the year.
=MONTH( date )
date a value that represents a valid date, be that numeric or string also.
The result is 9.
UK Date Format
FORM
In a Form you could set the Default Value of a Textbox to
=MONTH(#1/9/2012#)
VBA
In a Form add a TEXTBOX control and rename it "txtMonth", then you could add the following in the Load Event.
Private Sub Form_Load()
txtMonth = Month(#1/9/2012#)
End Sub
Course
Access Expert 11
Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
|