Results 1 to 7 of 7

Restrict text entry in textbox to JUST TEXT

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-01-2009
    Location
    Cincinatti,Ohio
    MS-Off Ver
    Excel 2003
    Posts
    122

    Restrict text entry in textbox to JUST TEXT

    I have a text box that I am using as the "search target" and to add to the database sheet. I need a way to make sure the user does not enter any spaces or funny characters that would make it more difficult to find the match when they want to search the database sheet at a later date.
    For example if the user types in:

    TEST123
    it will get added to the database,

    Then when they are trying to search the database they might accedentaly type in:
    TEST 123

    The SPACE will cause the database search macro to not find a match.
    The search macro is not case sensitive, but is sensitive to any spaces..
    Plus I think it will be easier for them to remember if it has to be ONLY Text and NO SPACES.
    I Hope this makes sense, please ask if you need more clarification.
    Thank you for your time,
    Last edited by TheNewGuy; 07-24-2009 at 03:54 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1