Unless you set the format property of the new field in the query to Short
Time, it will display the full time.
When you attempt to use the results of the query in a form or report, the
field data is passed to the control on the form (not the formatted display
text). On the report or form, you will have to use the format property of the
control and set it to Short Time.
If for some reason you are not seeing this then there is some problem that
exists with your application.
Try use the Format Function in the query to force a conversion to a string'
Field: MyshortTime: Format([MyTimeField],"Short Time")
Also check your computer OS settings under Regional and Language options and
see if that is affecting the Short Time format.
Instead of using the built-in Short Time function use
Format([MyTimeField,"hh:nn")
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County