validation

pab006 · November 27th, 2003, 09:27 AM

Hi,
I have a page which updates a database. Within this page is a field where a user may enter a decimal number. I only want the usert to be bale to enter .0, .25. .5 or .75 of any given number. How do i do this. I orignall tried using wildcards ie *.35 etc, but this didnt seem to work.

any help would be greatly appreciated

Paul

pgtips · November 27th, 2003, 12:13 PM

Try this, where x is the number you want to check:

Code:

If Fix(x * 4.0) = (x * 4.0) Then
    ' its OK
Else
    ' its not OK
End If

pab006 · November 28th, 2003, 05:25 AM

ill give it a go many thanks