Add one month to a text string? (2 Viewers)

[ghudson]

I have a text field "CurrentMonth" that will always be the full name of a month. Example (January, March, ext.) I am pulling the data into a text box in a report like this...
=[CurrentMonth]

I can also pull it in like this using the format function to ensure it is read as a month date.
=Format([CurrentMonth],"mmmm")

How can I add one month to the data value so that value will always be the next month. Example: a January value should be displayed in the text box as February.

Thanks in advance for your help!

 

[Mile-O]

If you had a full date aas opposed to just the name of a month then it is possible that you could use the DateAdd() function.

value/object = DateAdd("m",1,[Current Month])

 

[ghudson]

Thanks for your suggestion Mile-O-Phile. Ricky gave me the short answer I was looking for with this...

Format(DateAdd("m",1,CDate([CurrentMonth] & "/01/03")),"mmmm")

Thanks!