msg( Format(arrVal(0),"dd-mmm-yyyy") & " exists already")

--
Kind regards,

Niek Otten

"TUNGANA KURMA RAJU" wrote in
message ...
if e.offset(1,0)=arrVal(0) then
msg( arrVal(0) & " exists already")
In the above code arrVal(0) is a date I am getting it in message box as
12/5/2005.
I want this as 05-DEC-2005.What additional lines I ahve to insert to get
the
result what I need?.