• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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