Format with colons

[tlove161]

I have a form with a field to collect times. I want to be able to enter the time as "2130" for example and have a colon added when the record is stored in the underlying table such as "21:30".

I have had no success in accomplishing this. Any guidance is appreciated. Thanks.

Troy

 

[PHV]

Use a real DateTime field in your table and then simply play with display format and input mask.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886