how do I default enter last month?

[Guest]

Hi -

I would like a text box to auto-enter the month previous to today (whenever
the form is opened). I have been experimenting with =month([Today])-1, but
this yields the "Name?" in form view. The format of the field is mmmm yyyy.

Thank you.

 

[Rick Brandt]

Hi -

I would like a text box to auto-enter the month previous to today
(whenever the form is opened). I have been experimenting with
=month([Today])-1, but this yields the "Name?" in form view. The
format of the field is mmmm yyyy.

Thank you.

Set the default value property to =DateAdd("m", -1, Date())

 

[Guest]

Put this in the Default Value --
Format(DateAdd("m",-1,Date()),"mmmm yyyy")