I have a large athletic club record database, all the information is in the database already however im having issues with one field.

The field has to contain both distances in metres and centimetres AND times in hours minutes seconds and hundredths what would be an appropriate format for such a field? currently i have it set as a text field, though as expected this causes a mulititude of problems on sorts.

thanks

You are creating needless problems for yourself. You can store each field separately in your table and bring them together in a concatenated field in forms or reports. any other course of action leads to tears before bedtime!