I'm trying to display the next month in a text field

[gmazza]

Hi there,
I've gone through all the forms and can't seem to get the code straight for
displaying the next month on a text field on my form.
I just want the entire month name and nothing else and I have been struggling
with:
DateSerial(Year(Date()), Month(Date()) + 1, 1)

but its showing the day and year too and thats not what I need.
Thanks in advance!
GM

 

[Guest]

You need to look at te Format() function.

Format(YourExpression,"mmm")

That will display your date expression as a full month name.

Steve

 

[Marshall Barton]

Hi there,
I've gone through all the forms and can't seem to get the code straight for
displaying the next month on a text field on my form.
I just want the entire month name and nothing else and I have been struggling
with:
DateSerial(Year(Date()), Month(Date()) + 1, 1)

but its showing the day and year too and thats not what I need.

MonthName(Month(Date()) + 1)

 

[John W. Vinson]

Hi there,
I've gone through all the forms and can't seem to get the code straight for
displaying the next month on a text field on my form.
I just want the entire month name and nothing else and I have been struggling
with:
DateSerial(Year(Date()), Month(Date()) + 1, 1)

but its showing the day and year too and thats not what I need.
Thanks in advance!
GM

One quick & dirty way is to use this expression and set the Format property of
the textbox to

"mmmm"

John W. Vinson [MVP]

 

[gmazza via AccessMonster.com]

Thanks Steve, that does work, but when I add 1 to it, I get an error.
I just want The current month + 1 to always show up.

You need to look at te Format() function.

Format(YourExpression,"mmm")

That will display your date expression as a full month name.

Steve

Hi there,
I've gone through all the forms and can't seem to get the code straight for

[quoted text clipped - 6 lines]

Thanks in advance!
GM

 

[gmazza via AccessMonster.com]

Thanks Marshall, but its not a specific month I need, I need 1 added to the
current month. Is there a way I can do that with your expression?

Hi there,
I've gone through all the forms and can't seem to get the code straight for

[quoted text clipped - 4 lines]

but its showing the day and year too and thats not what I need.

MonthName(Month(Date()) + 1)

 

[gmazza via AccessMonster.com]

Good call John, that worked, and you're right, it is a little dirty way to do
it but I'll take it!
Thanks for your help everyone!!
GM

Hi there,
I've gone through all the forms and can't seem to get the code straight for

[quoted text clipped - 6 lines]

Thanks in advance!
GM

One quick & dirty way is to use this expression and set the Format property of
the textbox to

"mmmm"

John W. Vinson [MVP]

 

[Marshall Barton]

One of us is confused ;-)

As far as I can tell, my expression and John's suggestion
are just two different ways of getting the same result.
--
Marsh
MVP [MS Access]

Thanks Marshall, but its not a specific month I need, I need 1 added to the
current month. Is there a way I can do that with your expression?

Hi there,
I've gone through all the forms and can't seem to get the code straight for

[quoted text clipped - 4 lines]

but its showing the day and year too and thats not what I need.

MonthName(Month(Date()) + 1)

 

[John W. Vinson]

As far as I can tell, my expression and John's suggestion
are just two different ways of getting the same result.

and yours is cleaner... must have been something lost in transition there!

John W. Vinson [MVP]