MS Access Question

[Jim McColl]

Greetings - I am using MS Access 2000. I have designed a form for
maintaining a database. One of the fields is a yes/no field called
"PaidCurrentYear". There is another field called "MonthPaid".

When I click on the yes/no (PaidCurrentYear) field, I want to automatically
default the "MonthPaid" field to the current month abbreviated such as Jan,
Feb etc.

The way I am trying to do this is by using a "SetValue" action in a macro
associated with the On Click property for the "PaidCurrentYear" field. The
only problem I am having (I think) is that I do not know how to specify the
expression to return the 3 character month field in order to correctly set
this value into the "MonthPaid" field.

Needless to say, I am not an expert in regards to MS Access. I have done a
lot of searching on the Internet, but can't seem to find an example for what
I am treying to do. I would appreciate any assistance

Thanks

 

[George Nicholson]

=Month(Now()) returns 3
=MonthName(Month(Now()),True) returns Mar
=MonthName(Month(Now())) returns March

HTH,

 

[Jim McColl]

Thanks George - Only problem is the MonthName function is not available in
Access 2000

 

[George Nicholson]

In that case, try:
Format(Date(),"mmm")

 

[Jim McColl]

Brilliant George! - That did the trick

Many Thanks