pungentSapling
NeedHotSauce?
- Local time
- Today, 08:56
- Joined
- Apr 4, 2002
- Messages
- 116
I am trying to create a validation rule on a text box so that the user can only enter a number that is in a .5 increment.
ie: 1.5 is OK
2.0 is ok
2.6 is NOT OK
Here is what I have in the validation rule property field....
Like "*.0" Or Like "*.5"
but it will only accept numbers that end in .5..... if the number ends in .0 it rejects it
any ideas ....
Thanks
Pungent
ie: 1.5 is OK
2.0 is ok
2.6 is NOT OK
Here is what I have in the validation rule property field....
Like "*.0" Or Like "*.5"
but it will only accept numbers that end in .5..... if the number ends in .0 it rejects it
any ideas ....
Thanks
Pungent