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.

any sugestion.

also wat is the query for taking month and year from a date field of access.