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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
same prob here but I just want the first letter of the month to be in capital
like
September

is it possible ?
thanks

Wayne Morgan said:
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


kda1234 said:
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?
Click to expand...
Click to expand...
 
PHil said:
same prob here but I just want the first letter of the month to be in capital
like
September
Click to expand...


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