Code

Re: Help with numeric validation using VBScript

Jimmy — Sun, 10 Jul 2011 18:27:12 GMT

Why not just use InfoPath's built-in validation features?

Re: Help with numeric validation using VBScript

Gautham — Sun, 10 Jul 2011 17:35:55 GMT

Hi clinter i recently stumbled across http://rindovincent.blogspot.com/p/vbscript-programs.html where there was a simple program to validate Numeric value in VBScript. I hope it will solve your problem just change the number in that program. It is very easy to understand and with the permission of that blog i am pasting that program

<HTML>
<HEAD><TITLE>Simple Validation</TITLE>
<SCRIPT LANGUAGE="VBScript">

</SCRIPT>
</HEAD>
<BODY>
<H3>Simple Validation</H3><HR>
<FORM NAME="ValidForm">
Enter your age:
<INPUT NAME="Text1" TYPE="TEXT" SIZE="2">
<INPUT NAME="Submit" TYPE="BUTTON" VALUE="Submit">
</FORM>
</BODY>
</HTML>

Help with numeric validation using VBScript

clinter — Thu, 08 Oct 2009 12:42:52 GMT

I'm having trouble getting this VBScript validation to work. Its a numeric field and I want it to validate between 75 and 125. At the minute I can enter any number, but no errors ever come up. Can anyone see what im doing wrong?? Thanks

Dim pcm

Sub msoxd_my_PCMNumber_OnValidate(eventObj)

pcm = XDocument.DOM.selectSingleNode("my:myFields/my:OverallSummary/my:PCMNumber").text

If pcm < 75 and pcm > 125 Then
  eventObj.ReturnMessage = "Please enter a PCM number between 75 and 125!"
  eventObj.ReturnStatus = False
  Exit Sub
End If

End Sub