data validation in text box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Faisal - 01 May 2008 06:47 GMT

i want to enter some data in text box,But i should not enter any value in
text box,The data what i enter is should same as what i predifines by using
an another table

any tips on this
Regards
Faisal
Riyadh

Reply to this Message

default105 - 01 May 2008 06:48 GMT

Not sure if I follow but here goes. You have data in one table you want the
user to use and stay confined to. If this is the case use a combo box and
set up the not in list event to control the users actions. It is considered
nice to code it to allow the user to add the item to the list if it is not
there if you want them to have that capability. Hope this helps

Signature

Pete Blackburn - words to live by:
"Don''t ever let somebody tell you. You can''t do something.You got a
dream,You gotta protect it." Edited Quote from the Pursuit Of Happiness

> i want to enter some data in text box,But i should not enter any value in
> text box,The data what i enter is should same as what i predifines by using
[quoted text clipped - 4 lines]
> Faisal
> Riyadh

Reply to this Message

Faisal - 03 May 2008 05:15 GMT

Deat sir,

my thanks in advance for your reply

Actually i want to know that there there is any way to control text box for
data entry ,like the combo box property limit to list set to true

> Not sure if I follow but here goes. You have data in one table you want the
> user to use and stay confined to. If this is the case use a combo box and
[quoted text clipped - 10 lines]
> > Faisal
> > Riyadh

Reply to this Message

Linq Adams - 03 May 2008 18:37 GMT

In the BeforeUpdate event of your textbox use the DLookup() function to
insure that the value entered is present in the table. If the value isn't
found in the table

Cancel = True
Msgbox "Value not found! Try again!"

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message