What data validation should I use if I want text but not number?

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / New Users / March 2006

What data validation should I use if I want text but not number?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 02 Mar 2006 22:15 GMT

Hi

Please could you help me

I want to enter text only (NO NUMBERs ALLOWED) What should I type.

Chris

Reply to this Message

Sandra Daigle - 02 Mar 2006 22:39 GMT

Try putting the following into the validation rule of the field in the
table:

Not Like "*[0-9]*"

Signature

Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

> Hi
>
[quoted text clipped - 3 lines]
>
> Chris

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.