Formatting time

[PieBorg]

I'm a newbie having trouble formatting time values in a text box on a report. The control source is =[AsnmStartTime] & " to " & [AsnmEndTime]. The time values are stored as date/time in their table, formatted as medium time, with an input mask of 99:00\ >LL;0;_. They display correctly on other forms (for instance 12:00 PM), but on the report, the seconds have been added at the end (12:00:00 PM). How do I get rid of those seconds on the report? Do I need to break the control source up into multiple text boxes?

Thanks in advance for any helpful suggestions!

[Mickjav]

Go to the text box on the report and add the format short time or medium Time or use something like this "hh:nn AM/PM" in the format property