Kelly,
If you are trying to store a duration (minutes) in a time field, then you
are using the wrong datatype. Date/Time fields are for storing just that,
dates and times.
If, on the other hand, you are storing time values, but only want to display
the minutes portion of the time (cannot imagine why you would want to do
this), then you need to use the Format function in the control source of a
textbox on your form. Something like:
ControlSource:=Format([TimeField], "nn")
Note that I've used 'n' not 'm' in this function. 'm' refers to month.
--
HTH
Dale
email address is invalid
Please reply to newsgroup only.
Kelly said:
I need to convert a field that is in short time from hours and minutes to
minutes. I found this answer before but since redoing my database I have not
been able to find the answer back. Any help would be appreciated.
Thanks,
~Kelly