Formatting Dates

  • Thread starter Thread starter S. Jackson
  • Start date Start date
S

S. Jackson

I am trying to format a text box that has a control source which provides
the name of the month that the user has selected. I have figured out how to
format the text box to display the full name of the month, i.e., "July"
instead of "7" by putting "mmmm" in the Format Property of the text box.
Now, how do I make the month also be displayed in upper case? Can I do
that?

S. Jackson
 
S. Jackson said:
Yes, I tried "MMMM" but Access automatically changes it to the lower case.

Thanks for your thoughts anyway!

S. Jackson
Click to expand...

Use the Format() function instead of the format property. Since that returns a
string you can wrap UCase() around it.
 
Not that I have anything useful to add in the way of a solution here, but I
want to rant about this. I have had and still have problems with this, and
not just with Access. Microsoft does not support alternative date
formatting. If you want it your way it has to be a string and you can not
perform any analysis on the date data. And I don't want to hear any of the
stuff the help file gives about US Date format because in the military we do
not use mm/dd/yy it's d MMM yy. Anyone else agree?

Sean
 
Dear Rick:

Thank you for your reply. However, I don't have a bloody clue what you are
trying to tell me. I DO NOT understand how to write
functions/code/expressions. They never, EVER, seem to work for me.

Sorry if I'm ranting. I'm not ranting at you, just in general at my
frustration my ignorance! Can you please show me by typing it out for me?
Thanks.

S. Jackson
 
S. Jackson said:
Dear Rick:

Thank you for your reply. However, I don't have a bloody clue what you are
trying to tell me. I DO NOT understand how to write
functions/code/expressions. They never, EVER, seem to work for me.

Sorry if I'm ranting. I'm not ranting at you, just in general at my
frustration my ignorance! Can you please show me by typing it out for me?
Thanks.
Click to expand...

=UCase(Format([YourDate],"mmmm"))
 
Back
Top