date/time using Format()

I'm reformatting a date taken from a database, which is stored in the following format, where days/months/hours/minutes/seconds all have leading zeros:

DD/MM/YYYY HH:MM:SS AM/PM

I've already formatted it to how I want it, using this:

VB Code:

dateFormat = "d/mm/yy h:mm"
        Format(CDate(qry!Time), dateFormat)

This outputs the date as d/m/y h:m, with leading zeros only on months, years and minutes, and it works fine. The problem is that I can't get it to preserve the AM/PM, so is there any way to add that to it too using Format()? (and not resorting to using Left to get it from the original field value)

dateFormat = "d/mm/yy h:mm AMPM"

You have to specify AM/PM as your format:

Format(Now, "D/MM/YY H:NN AM/PM")

Try

VB Code:

dateFormat = "d/mm/yy h:mm AM/PM"
        Format(CDate(qry!Time), dateFormat)

neato, thanks RhinoBull/tward.

you're two minutes too late, but I suppose I could thank you as well Sean.