Forum Discussion
Minutes and Seconds Field
Hi everyone, somewhat new to the world of access, and I have run into a seemingly simple problem, that I cannot find an answer to online. How can I create a field, with the format minutes and seconds...
Jqws13_ wrote:
I am not particularly wanting to avoid entering hours if that's what it means to make this easy.
Then that is your solution.
You only miss to change the Format property of the textbox where you display the value to:
nn:ss
Remove an InputMask. It often causes more trouble than help.
Hi Gustav,
Here is my solution, and so far it has seemed to work. My custom format is nn:ss, and my input mask is "00":99:00;0;0* The hours are set to 0, which is what I wanted, and I can enter whatever amount of minutes and seconds as I like, and it will only appear with minutes and seconds.
Here is my solution, and so far it has seemed to work. My custom format is nn:ss, and my input mask is "00":99:00;0;0* The hours are set to 0, which is what I wanted, and I can enter whatever amount of minutes and seconds as I like, and it will only appear with minutes and seconds.
