- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Coaching Changes
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Microsoft Access 2007 question
Posted on 1/24/10 at 7:24 pm
Posted on 1/24/10 at 7:24 pm
Never really used this before, probably a stupid question, but...
How do I get it so that the database allows you to only use letters and spaces, no numbers.
Thanks for the help!
How do I get it so that the database allows you to only use letters and spaces, no numbers.
Thanks for the help!
1
Posted on 1/24/10 at 10:08 pm to Halpert
Try to check for the ASCII value of the input keys - Use the Asc Function to check the ASCII value of the entries. Uppercase is 65 to
90, lowercase is 97 to 122, space is 20.
You can also just do an IsAlpha() for the alphabets (it would merely call the Asc function and check for 65-90 and 97-122) and check separately for the space.
I have used earlier versions of MS Access - so there might be newer and easier ways to do this now.
90, lowercase is 97 to 122, space is 20.
You can also just do an IsAlpha() for the alphabets (it would merely call the Asc function and check for 65-90 and 97-122) and check separately for the space.
I have used earlier versions of MS Access - so there might be newer and easier ways to do this now.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News