change no. month to text month

[Guest]

I would like to change numbers to equal months for example the 1 = January,
2=February 3=march etc.... so when I type in 1 january will appear etc....

 

[Guest]

Hi Debbie -- Lookup the MonthName function is the help file. This will help
get you started.

 

[Guest]

wasn't able to get it to work - maybe I'm not doing something right... but at
least I know this can be done - the question is how and where do I insert
this - under query???

 

[Guest]

If you want it to change after you type, you'll need to use an event through
VBA. For example, you can use the AfterUpdate event and try the following:

FieldMonth = MonthName(FieldMonth)

Replace FieldMonth with the name of your field. To add an event, in design
view, right click on the field and select properties. Go to the events tab
and click the elipse (...) next the AfterUpdate event and select code
builder. Add the above code and test it out.

 

[Guest]

where / how do i do this

If you want it to change after you type, you'll need to use an event through
VBA. For example, you can use the AfterUpdate event and try the following:

FieldMonth = MonthName(FieldMonth)

Replace FieldMonth with the name of your field. To add an event, in design
view, right click on the field and select properties. Go to the events tab
and click the elipse (...) next the AfterUpdate event and select code
builder. Add the above code and test it out.

 

[Guest]

Hi there - Just wanted to let you know that I spent some more time on it and
got it to work!!! thanks so much

Debbie

 

[Guest]

I'm sorry - just one more thing - when working on it... I had to go and
delete a month because I needed more information. When I did this I got this
error message:
Runtime error '94':
Invalid use of Null

what is this about and what can I do to correct it. Did I do something
wrong??