Hi

I'm writing a 'time' class that will take a field (in either proper datetime format, secs past midnight or a string of format 'hh:mm') and allow the user to alter the time on screen in the 'hh:mm' format.

When saving the time back to the control source, I'll be converting the 'hh:mm' back to the original format.

I'm trying to do this so that it is fairly transparent when developing forms (i.e. the developer doesn't have to call the conversion methods of the class when moving to a new record, saving, restoring etc).

To achieve this, would I use something like the Value_Access and Value_Assign methods to intercept the value property between table and screen, or do I have to intercept the ControlSource property instead?

Or can someone suggest better solutions?

Thanks in advance for any pointers.

Pete