How do I format a date to print in all capital letters?

[Guest]

I have a form that ask for a date. This date is then used to print at the
top of a report in the following line: TODAY, (Date), AT 9:30 AM. In the
control source for the text box I typed in "TODAY, "&Format([Date],"MMMM d"",
""yyyy")&", AT 9:30 AM". By typing the "MMMM" in capitals I thought that the
month then would print in capitals but this turned out not to be the case.
How do I get the month to print in capitals?

 

[Wayne Morgan]

Do you want just the month in all caps or the entire line? Although, with
what you have it probably doesn't matter. The only thing not already
capitalized is the name of the month.

Entire line:
UCase("TODAY, " & Format([Date], "MMMM d"", ""yyyy")&", AT 9:30 AM")

It is recommended that you DON'T use reserved words, such as Date, as field
names, variable names, or procedure names. It could cause you problems
unless you are very careful.

 

[PHil]

same prob here but I just want the first letter of the month to be in capital
like
September

is it possible ?
thanks

Do you want just the month in all caps or the entire line? Although, with
what you have it probably doesn't matter. The only thing not already
capitalized is the name of the month.

Entire line:
UCase("TODAY, " & Format([Date], "MMMM d"", ""yyyy")&", AT 9:30 AM")

It is recommended that you DON'T use reserved words, such as Date, as field
names, variable names, or procedure names. It could cause you problems
unless you are very careful.

--
Wayne Morgan
MS Access MVP

I have a form that ask for a date. This date is then used to print at the
top of a report in the following line: TODAY, (Date), AT 9:30 AM. In the
control source for the text box I typed in "TODAY, "&Format([Date],"MMMM
d"",
""yyyy")&", AT 9:30 AM". By typing the "MMMM" in capitals I thought that
the
month then would print in capitals but this turned out not to be the case.
How do I get the month to print in capitals?

 

[Marshall Barton]

same prob here but I just want the first letter of the month to be in capital
like
September

That's the normal way that dates are formatted. What did
you do to prevent the first letter from being capitalized?