how do I default enter last month?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Morgan - 31 Mar 2006 01:57 GMT

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.

Reply to this Message

Rick Brandt - 31 Mar 2006 02:06 GMT

> Hi -
>
[quoted text clipped - 4 lines]
>
> Thank you.

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

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

KARL DEWEY - 31 Mar 2006 02:21 GMT

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

> Hi -
>
[quoted text clipped - 3 lines]
>
> Thank you.

Reply to this Message