Date format

[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.

 

[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.

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