Input Mask Question

[data808]

I want to set up an input mask for one of my field boxes on a form. I am making a movie database and would like to enter the length of the movie into a field. I would like it to look like this for example: 1hr 45mins if I type 145.



Take it a step further and if I could just type in the amount of minutes the movie is and then it will break it down into hrs and mins for me that would be even better. For example: if I type in 90 it can break it down for me as 1hr 30mins.

The second way would be super awesome but the first way is good enough too. Now that I think about it, it will probably take a macro or VBA to do this. Can anyone help with that?

Any help is appreciated.

Thanks.

[June7]

Try:
Int(minutes / 60) & "hrs " & minutes mod 60 & "mins"

[data808]

Is this an incomplete code? Do I put it in Form event? or on the field itself.

[June7]

Can put that expression in a query to create a field or in textbox ControlSource.