formatting Time in VBA

[Joseph Schroeder - Vazcom]

Is there a way to have VBA insert the colon seperator for HH:MM in access

I have the text box on the form where the time is entered set to Date/Time
format, and the underlying tables field set to Date/Time as well.

When a user enters a time say for example 0800 it comes up with an error
(Data entered is not correct format), is there a way to NOT have to manually
enter the ":" ?

I have seen this done before but no longer have access to the resource where
it was done.

Any help in this matter will be greatly appreciated

Thanks

 

[freakazeud]

Hi,
wasn't your question answered here:
http://www.utteraccess.com/forums/s...=d&olderval=&oldertype=#Post1170244&bodyprev=
HTH
Good luck