Disallow word in a bound text box

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

Access 2000, Win XP SP 2

I have a form for entering information on a vendor. It's bound to a query
against the vendor table.

In the fldVendorName field, I'd like to disallow any use of one particular
word (because that vendor is not allowed to do business with us).

What's the best way to do this? Is there some sort of check that can be
performed on exit of the field? Then if this word is there, pop up an error
message and erase the entry?

Open to suggestions for how to ensure this vendor doesn't get into the
database. Thank you.
 
Allison said:
Access 2000, Win XP SP 2

I have a form for entering information on a vendor. It's bound to a query
against the vendor table.

In the fldVendorName field, I'd like to disallow any use of one particular
word (because that vendor is not allowed to do business with us).

What's the best way to do this? Is there some sort of check that can be
performed on exit of the field? Then if this word is there, pop up an error
message and erase the entry?

Open to suggestions for how to ensure this vendor doesn't get into the
database.
Click to expand...

Use the text box's BeforeUpdate event:

If Me.txtVendor Like "*theword*" Then
MsgBox "Vendor is not allowed"
Cancel = True
Me.txtVendor.Undo
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem locking bound controls 5
Access Sorting and grouping using multiple tables 0
Blank fields when adding new record to combo box 7
Combo Box Overwriting Table 3
Show Vendor Name 14
How open a form with a blank record 1
combo box - bound column 2
Sort in VB using a ComboBox Column Other than the Bound Column 4

Back
Top