[AccessD] Quarter hour increments

Ken Ismert KIsmert at texassystems.com
Fri Oct 21 18:19:06 CDT 2005


Gina, 

>>we'd like to restrict them to quarter hour increments.

Just put this code in the AfterUpdate event for the form control:

Private Sub txtTaskHours_AfterUpdate()
    Dim sgHours As Single
    ' Round to nearest quarter
    sgHours = CSng(Round(txtTaskHours.Value * 4) / 4)
    txtTaskHours.Value = sgHours
End Sub

-Ken 



More information about the AccessD mailing list