Hi, I have 2 fields Time_from and Time_to. They are both time fields.

They are formatted as 24 hour HHMM.

when you click on the fields they show the time and the seconds and I can not get rid of the seconds, any ideas?

Edited January 22, 201016 yr by Guest

- use a drop down or pop-up menu with just the times the user can select

- use two separate number fields: one for hours, one for minutes so that you can construct the time in the background

In Layout mode with the field hi lighted- Go to Format-Time- and then pick from the styles HH:MM:SS or HH:MM etc.

That part is easy but what I would like it to do is enter the : automatically like can do in MS Access. There must be a way but I can;t figure it out.

Edited January 24, 201016 yr by Guest

You can use the onkeystroke event for this but only with a few assumptions:

the ":" would be entered after the user entered the 2nd digit -> only if they don't need to enter times > 100 hours

See also:

http://fmforums.com/forum/showtopic.php?tid/190048/post/266638/#266638