[AccessD] Long Time Format difference A97, A2k, A2k3

I am converting old A97 systems to A2k3. I have to go through A2k first.

There is a section in my code where I take a flat file with a date and
time in separate columns, I convert both and then combine them. For the
time conversion I have been using "LONG TIME" I works fine for almost 9
years in A97.  When I test it in A2k I get error 13 type mismatch with
the time conversion.  

I checked it through the immediate window and see that A2k adds an extra
colon : at the end of the number.  I double checked the A97 and it comes
out correctly.  So I also checked A2k3 and it also adds the extra colon
:

If I use the "hh:nn:ss am/pm"  then it does not add the extra colon.  

Has anyone else run into this problem? Does anyone know why M$ changed
how this works?

Thanks in advance 
Patti

-------------------------------------------
Access 2k

?format(now(),"long Time")
12:50:35: PM
?format("14:57:44","long time")
02:57:44: PM
?format("10:57:44","long time")
10:57:44: AM
?format("11:57:44","hh:nn:ss am/pm")
11:57:44 am
?format("15:57:44","hh:nn:ss am/pm") 
03:57:44 pm
--------------------------------------------
Access 97

?format(now(),"long Time")
12:49:54 PM
?format("15:57:44","long time")
03:57:44 PM
?format("11:57:44","long time")
11:57:44 AM
?format("11:57:44","hh:nn:ss am/pm")
11:57:44 am
?format("15:57:44","hh:nn:ss am/pm")
03:57:44 pm
-----------------------------------------
Access 2003

?format(now(),"long Time")
12:49:16: PM
?format("11:57:44","long time")
11:57:44: AM
?format("15:57:44","long time")
03:57:44: PM
?format("15:57:44","hh:nn:ss am/pm")
03:57:44 pm
?format("11:57:44","hh:nn:ss am/pm")
11:57:44 am


Thanks
**************************************************
* Patricia O'Connor
* Associate Computer Programmer Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (w) mailto:aa1160 at nysemail.state.ny.us
************************************************** 
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system.