Title
Logic on typing format
Post
Is there a way in data entry mode to type in a field, the format always being 0000 or 000000 and have it update to 00:00 if four character were typed and 00:00:00 if six characters were typed? Then if the user types 00:00 or 00:00:00 the field will just accept it?
Try this calculation in the auto-enter options for that field: