pure time format

[iccsi]

I need to dispaly pure time format like mm:ss in continue form.
I can use datetimepicker on the format to change format to mm:ss even
the field type is datetime.

I have the field in the continue form which does not let me to show
the format using datetimepicker.

I would like to know are there any way to show pure time format in
continue form using datetime field type.

If there is no solution then I have to change the datetime field in
interger to save secoonds and convert to string by myself.

Your information and help is great appreciated,


iccsi

 

[Access Developer]

I understand that you are displaying data in continuous forms view (in which
view, you might normally display the time in a text box, in which case,
there is a Format property that you can set in design view). Perhaps there
is more to this than I see from reading your description? I'm sorry, but I
don't understand your focus (obsession?) with DateTimePicker. Are you
entering data into this field, are you allowing entry of more than time, but
only want to display time, or are there other constraints?

Just by the way, when specifying details of date/time format "m" is used for
month, and "n" is used for minutes.

Also, by the way, what version of Access are you using? If I recall
correctly, the combination of online and offline Help in Access 2003 is very
useful in describing how to specify formats for date and time; and I'd guess
the Help in later versions would also be useful.