Day
Using the DAY Function
In this tutorial you will learn how to use the DAY Function.
The DAY function returns an Integer specifying a whole number between 1 and 31, inclusive, representing the day of the month.
=DAY( date )
date a value that represents a valid date, be that numeric or string also.
The result is 1.
UK Date Format
 FORM
In a Form you could set the Default Value of a Textbox to
=DAY(#1/9/2012#)
 VBA
In a Form add a TEXTBOX control and rename it "txtDay", then you could add the following in the Load Event.
Private Sub Form_Load()
txtDay = Day(#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
| 
