I'm not sure that I understand your question. When you say " I want to
restrict values to uppercase letters from A-B inclusive" aren't you saying
you want to restrict values to A or B? Also, are you trying to restrict the
data being entered into the text box or the data in the underlying recordset
that is displayed in a bound textbox?
When using > and < with characters, it is best to convert the character to
its ASCI equivalent so >= "A" becomes >=ASC("A")
Guy Harley
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of ME
Sent: Thursday, 2 February 2006 3:23 AM
To: [email protected]
Subject: [ms_access] validation rule for text box
Text Box properties-
validation rule-
I want to restrict values to uppercase letters from
A-B inclusive in TextBox1
I want to restrict values in another Text Box,
TextBox2, depending on the letter
entered in TextBox1
I tried using the Expression Builder to come up with
the following rule for
TextBox1:
=[txt]>="A" And [txt]<="B"
but everything I enter, A, B, Z, a, b, etc. fails the
validation test. I can't get to the second test until
I get the first to work. I tried setting the
validation rule in both the form and the table but
neither worked. Can someone please help?
Thanks,
Mark Espinosa
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
