Set the format property of the text box on the form or report that displays
the value.

--
Duane Hookom
MS Access MVP


"Abeer" wrote in message
...
how do i convert the short date format from mm/dd/yy to
dd/mm/yy