Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

VBScript To Add Blank In A Field

I need a vbscript code that will look in a field, find < > and make the field blank if it finds the "<" or ">"

If field5 contains "<" or ">", then make field blank or empty.
0
gbautista34
Asked:
gbautista34
1 Solution
 
Paul-BCommented:
Try the following but using the name of your form in place of "TheForm" and of course the right field name in the case its not actually called field5..

If InStr(TheForm.field5.Value,"<") > 0 Or InStr(TheForm.field5.Value,">") > 0 Then TheForm.field5.Value = ""

Open in new window

0
 
gbautista34Author Commented:
Excellent and quick!  I appreciate the help.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now