Date format

K

Kitty

when i use the format like mmm dd, yyyy... the month will display like "Sep
14, 2004", can access display the month using capital letters like "SEP 14,
2004" ?

thx in advance.
 
F

fredg

when i use the format like mmm dd, yyyy... the month will display like "Sep
14, 2004", can access display the month using capital letters like "SEP 14,
2004" ?

thx in advance.
Click to expand...

As control source in an unbound text control:
=UCase(Format([DateField],"mmm d, yyyy"))
Make sure the name of the control is not [DateField].
 
Top