Date Format

[wasim_sono]

Hello All



I want to chage the value of Billingmonthfield as follows.

Date field Billingmonthfield

01-08-2006 072006

i.e. as user enter date in the date field the default value of BillingmonthFiled should be set to minus(-) 1 of month and same year.
It should be used a date function but I tried and never geeting the result.
Any one can help me?

Thanks.

[StepUP]

Format(DateAdd("m",-1,Me.Datefield),"mmyyyy")

[wasim_sono]

Dear John F
Thanks for ur reply. Can u tell me that where I write this code? either in control source or in VBA editor if in editor then at what's event.

Thanks.

Wasim