Default Value CurrentMonth

[Bruce]

I have an unbound textbox in a form that I want to autopopulate with the current month (text). I've tried setting the default value to Date(M), Now(M), =Format(Month) etc. Any suggestions? Thanks.

[RuralGuy]

Look up MonthName in VBA help.

[Bruce]

I tried to put =
=MonthName(month[, abbreviate]) in the "Default Value" field but it still
displays #Error. I can put in =Date(), =Time(), =Now() and all of these work. Do I have to create an "Event" Code procedure...like..On Dirty...?
If so, how would that read? I'm just learning VBA.

Thanks!

[RuralGuy]

This is an unbound control right? Just make it the ControlSource:
=MonthName(Month(Date()))

[Rainlover]

Try this as the Control Source

=Month(Date())

[Bruce]

Figured it out. In the "Default Value" field =Format(Date(),"mmmm")Access 2003 didn't know the common expression Month.

[Rainlover]

Not sure your comment is correct.

[RuralGuy]

So I would guess you are ready to follow the link in my sig and mark this thread as Solved.