[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to validate multiple text in the TextBox control

Posted on 2011-03-11
4
Medium Priority
?
347 Views
Last Modified: 2012-06-21
Hi I need help with validation of multiple control words in the TextBox.
I have this simple code, which validates the user into the TextBox wrote:

If Slide5.TextBox4.Value = "Prague" Then
Slide5.TextBox4.BackColor = &HC0FFC0
Else:
Slide5.TextBox4.BackColor = &HC0C0FF
End If


I want the textbox the words "Prague" also recognized and inserted the word "Prag", ie. If the user writes, "Prague" or "Prag", then change the color: .BackColor = &HC0FFC0
Thanks in advance for your help.
TM
0
Comment
Question by:Thomas_Meyer
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
4runnerfun earned 1200 total points
ID: 35111148
As in... ?
If Slide5.TextBox4.Value = "Prague" OR Slide5.TextBox4.Value = "Prag" Then
Slide5.TextBox4.BackColor = &HC0FFC0
Else:
Slide5.TextBox4.BackColor = &HC0C0FF
End If
0
 
LVL 59

Assisted Solution

by:Chris Bottomley
Chris Bottomley earned 800 total points
ID: 35111155
If Slide5.TextBox4.Value = "Prague" or Slide5.TextBox4.Value = "Prag"Then
Slide5.TextBox4.BackColor = &HC0FFC0
Else:
Slide5.TextBox4.BackColor = &HC0C0FF
End If
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 35111162
Snap ... ish!

Chris
0
 

Author Closing Comment

by:Thomas_Meyer
ID: 35111217
Thanks, it was so easy!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
I came across an unsolved Outlook issue and here is my solution.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question