Current month in a field as default

[leandrosarno]

I need help!

Can anyone help me?



How do I put the current month as the default value in a field of access?

Thank you!

God bless you all!

[ConneXionLost]

Hi leandrosarno,

If you're referring to a field in a table, then go to table design and select the field, then add this:

=Date()

to the Default Value attribute on the General tab (lower left of screen).

Cheers,

May reason prevail!

[leandrosarno]

Hi leandrosarno,

If you're referring to a field in a table, then go to table design and select the field, then add this:

=Date()

to the Default Value attribute on the General tab (lower left of screen).

Cheers,

May reason prevail!

I am glad that you answered my question about the code, however, I tried to use it. What I need is a code that returns me the name of the month.
Example: 02/07/2010, ie February.
I need the name of the month to make calculations of accountability.
I appreciate if you can help me.

[ConneXionLost]

Hi leandrosarno,

Same area as before, add "mmmm" to the Format.

Cheers,

[thhui]

Just fill in the following into the default value of the field you want in the table definition

=Format(Date(),"mmmm")

[leandrosarno]

Hi leandrosarno,

Same area as before, add "mmmm" to the Format.

Cheers,

Thank you,

I'll try and return the answer.
Wait until tomorrow, please.

God be with you

[leandrosarno]

Just fill in the following into the default value of the field you want in the table definition

=Format(Date(),"mmmm")

Thank you,

I'll try and return the answer.
Wait until tomorrow, please.

God be with you