Is there any was to make Sun, Mon, Tue, etc. all capitals?

[projecttoday]

The following:
=Format(datefield,"ddd")
produces Sun, Mon, Tue, etc.

Is there any way to make it come out all in capitals?

 

[MazeWorX]

check out the StrConv function in access help

HTH << MaZeWorX >> Remember amateurs built the ark - professionals built the Titanic [flush]

 

[projecttoday]

I will. Thanks.

 

[maxhugen]

Or UCase(Format(datefield,"ddd"))

Max Hugen
Australia

 

[EJVTECH]

Change:
=Format(datefield,"ddd")

To:
=StrConv(Format(datefield,"ddd"),vbUpperCase)

EJV