Creagting a date/time field which includes milliseconds, and no dates

[neillovell]

I am trying to create a field in my table which will let me enter times such as
01:33:83
1 minute 33 seconds 83 milliseconds

The problem I have right now is that if I put a number above 59 for the milliseconds the data is rejected (obviously it thinks it is the seconds field).

I've had a go with the masks but no luck - how do you do it?

Thanks,
Daniel

 

[LittleSmudge]

Your problem there is that the format xx:yy:zz is assumed to be hours:minutes:seconds

Have you tried entering
1:33.088

I don't think that will work - but it's worth a try.

If this is for user input - how about three separate controls for the three component parts. Store them in three separate fields and then just combine then when displaying of the forms and reports etc.




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[neillovell]

I'm entering the data myself, it is just very frustrating. I've seen the . used elsewhere but it does not like it for some reason. I'll keep trying.

 

[neillovell]

Ah, I can set the field type to be Date/Time then in the format property text box I can type 00\:00\:00\:00;00 and when entering times I just type 1988 for 00:00:19:88