LiveWire Network Peer Answers Peer Support Teen Forums Tech Forums College Forums 573 users online 178945 members 2054 active today Advertise Here Sign In
TeenCollegeTechPhotos | Quizzes | LiveSecret | Video | Dictionary | News | FAQ
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
5 online / 26 MPM
Fresh Topics
  LiveWire / Technical Forums / Programming & Application Development / Viewing Topic

need help with MS Access validation rules!
Replies: 1Last Post Mar. 18 11:11am by DefaultTo0
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?


9:59 am on Feb. 22, 2008 | Joined Dec. 2007 | 203 Days Active
Join to learn more about Sachacohen2 England, United Kingdom | Female | 978 Posts | 3253 Points
DefaultTo0


How are you gentlemen!!

Patron
Support Leader
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.

-------
My website » davidlyness.co.uk
Twitter updates » twitter.com/davidlyness


11:11 am on Mar. 18, 2008 | Joined July 2006 | 668 Days Active
Join to learn more about DefaultTo0 Northern Ireland, United Kingdom | Label Free Male | 9195 Posts | 24978 Points
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