first_page the funky knowledge base
personal notes from way, _way_ back and maybe today

Code: txtCopies_Exit() -- Data Validation on Exit

Sub txtCopies_Exit (Cancel As Integer) ' 'NOTE: This procedure contains line break characters 'for readability. These characters are not supported 'in Access Basic. ' ' 'This sub checks txtCopies for smart-ass values. 'We don't want txtCopies to have negative values 'or fractional values. ' If IsNumeric(Me![txtCopies]) Then If Me![txtCopies] >=1 Then Me![txtCopies] = _ CInt(Abs(Me![txtCopies])) Else Me![txtCopies] = 1 End If End Sub

mod date: 1999-09-09T22:36:59.000Z