Numeric increment

A

Annette

I need to create a form for users to enter the amount of time they
spent on a project. We are not interested in entering beginning and
ending times, just the total time spent on the work, however times can
only be in 15 minute increments. Therefore, the decimal portion of the
number can only be .25, .50 or .75. How can I force the 15 minute
numeric increment equivalent in a numeric field?
 
B

Bob Darlington

Hi Annette,
Try using the 'Mod' operator.
In the before update event of the field:
If fldMinutes Mod 15 <> 0 then
msgbox ..
Cancel = -1
 
J

James A. Fortune

I need to create a form for users to enter the amount of time they
spent on a project. We are not interested in entering beginning and
ending times, just the total time spent on the work, however times can
only be in 15 minute increments. Therefore, the decimal portion of the
number can only be .25, .50 or .75. How can I force the 15 minute
numeric increment equivalent in a numeric field?
Click to expand...

To the left of the "Search this group" button, type "quarter hour
validation," then click on the button. Click on the first link
returned.

James A. Fortune
[email protected]
 
C

Clif McIrvin

I need to create a form for users to enter the amount of time they
spent on a project. We are not interested in entering beginning and
ending times, just the total time spent on the work, however times can
only be in 15 minute increments. Therefore, the decimal portion of the
number can only be .25, .50 or .75. How can I force the 15 minute
numeric increment equivalent in a numeric field?
Click to expand...

To the left of the "Search this group" button, type "quarter hour
validation," then click on the button. Click on the first link
returned.


Real helpful reply for those of us on USENET :)
 
Top