Results 1 to 4 of 4
  1. #1
    udik is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Dec 2011
    Posts
    6

    Check text box string format

    I have a text box that should be in a format of ##X## or ###X### or ##X###.
    #- is a letter (number from 0-9).

    how do I chek (in code) that the above will be the only possible string format and user don't use other format.

    Thanks


    Udi

  2. #2
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    You could set up an input mask and force the issue...
    Last edited by Stingaway; 01-04-2012 at 01:24 PM. Reason: Changed "string" to "mask" because i posted the original response late at night...

  3. #3
    udik is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Dec 2011
    Posts
    6

    Didn't get you

    How to do it

  4. #4
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Look in the properties of the text field and look for "input mask"... run the wizard if necessary.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Text String.
    By cap.zadi in forum Queries
    Replies: 3
    Last Post: 11-08-2011, 09:30 AM
  2. text string
    By cbrsix in forum Reports
    Replies: 4
    Last Post: 10-27-2011, 02:24 PM
  3. check the format of an numeric inputted field?
    By eliotchs in forum Programming
    Replies: 1
    Last Post: 04-20-2011, 11:35 AM
  4. Format within a string
    By wdrspens in forum Reports
    Replies: 1
    Last Post: 04-16-2011, 05:51 PM
  5. Text string formatting
    By DanW in forum Forms
    Replies: 2
    Last Post: 11-02-2009, 11:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums