LiveWire Network Peer Answers Peer Support Teen Forums Tech Forums College Forums 826 users online 221717 members 1501 active today Advertise Here Sign In
TeenCollegeTechPhotos | Quizzes | LiveSecret | Memberlist | Dictionary | News | FAQ
Member Spotlight
JTHM
Music: My favorites have to be The Who, Red Ho...
Mood: Pleased
You have 1 new message.
Emergency Help
Until you sign up you can't do much. Yes, it's free.

Sign Up Now
Membername:
Password:
Already have an account?
Invite Friends
Active Members
Groups
Contests
Moderators
4 online / 54 MPM
Fresh Topics
  LiveWire / Technical Forums / Programming & Application Development / Viewing Topic

need help with MS Access validation rules!
Replies: 1Last Post Mar. 18, 2008 11:11am by DefaultTo0
Welcome to LiveWire!
We're Stronger Together.
Join the Community
Single page for this topic Email Print Favorite
( Sachacohen2 )


Dairy Product Addict
Reply
How do you write the validation rule for when you only want letters allowed no numbers?

Or what do you write when you only want numbers to be allowed nothing else?


-------
**WWW.SAVETHEINTERNET.COM/**http://www.spychips.com/
****http://www.liberty-human-rights.org.uk/*


9:59 am on Feb. 22, 2008 | Joined: Dec. 2007 | Days Active: 325
Join to learn more about Sachacohen2 England, United Kingdom | Female | Posts: 1,501 | Points: 5,085
LiveWire Humor
DefaultTo0


Swami

Patron
Tech Support Leader
Reply
Put 'number' as the data type - this will serve for all basic needs.

I believe that there is an input mask that you can use to specify only numbers.  I know that the letter 'L' means 'allow one letter'.  Unsure how to specify that it can be of any length though.

-------
What?


11:11 am on Mar. 18, 2008 | Joined: July 2006 | Days Active: 881
Join to learn more about DefaultTo0 Northern Ireland, United Kingdom | Label Free Male | Posts: 9,564 | Points: 29,727
Single page for this topic Email Print Favorite

Quick Reply

You are signed in as our guest.

Looking for something else?
 

  LiveWire / Technical Forums / Programming & Application Development / Viewing Topic