the Dtpicker format to show on the form is custom that is MMMM/yyyy.
now whenever change the value of dtpicker by its "change" function then if it has january and i increase its value to february then it shows february to view but the value it gives will be March in the below syntax:
Mnth = format(dtpicker1.value , "MMMM")
this bug only arise if the day value of january will be 31.
also wat is the query for taking month and year from a date field of access.