Format Problems for Text Boxs

[LizardKingSchwing]

Helloo

I have a form with a load of Text boxes and the data in these is a large number in seconds say 10000000 and I wanted to format this in the form of hh:mm:ss so I used the following Format( MySeconds / 86400, "hh:mm:ss" ) , this seemed to work for seconds values that did not go over the hh boundary i.e two digit amounts for the hours , when I got to values that are getting into the hundreds and thousands of hours the formatting was incorrect. Anyone know how to format this type of thing in VBA for Access 97

Cheers

LK--<

 

[LizardKingSchwing]

Even if I can get the format to show the following

Format DD hh:mm:ss

Where DD is the number of days and hh is hours and mm is mins and ss is seconds , based on an input or calculated integer value of seconds e.g 100000000 seconds what is this in Days,Hours,Mins,Seconds

Cheers

LK--<