Date Formating In A Label Print

I am new to Access and I have just imported my old ham radio logs from a DOS based Smart database - rememeber that one.

I have created a reasonable functioning table. I have also created a Query to sort certain records for which I want to print labels to affix to my radio card which I wish to send to other radio stations (called QSL cards). I have created a Report to run the Query and to print a label. Here is my label. It is a mixture of text strings and data from my log database Query.


To Radio 9U9Z QSL QSO
dd/mm/yy UTC Freq Mode RST
24-Feb-07 18:44:00 18.148 ssb 55
73's de Mark N1XX (WAB 11XXX)


Here is the code for the date time etc line - the 3rd line down on the label above - taken from the design view


=Trim([Date] & " " & [Time_UTC] & " " & [Frequency] & " " & [Mode] & " " & [Rpt_Sent])



I am not sure how to format the date to print just the hours and minutes. I would have hoped that since the main log table was using a short time that it would have folowed automatically. In fact the time was printing as 12 hour time and I had to go into my Windows XP preferences and change the pc to a 24 hr clock to get it to print as a 24 hour clock. I tried setting the pc to an hrs and minutes time but it didn't fix my label format. It still shows seconds. I would like to get label to print 24hr hours and minutes and be able to set my pc back to a 12 hour clock format.

Thanks for your help. I still have loads to learn with this database program.



thanks Mark