Results 1 to 2 of 2
  1. #1
    jacjacjac is offline Novice
    Windows XP Access 2000
    Join Date
    Dec 2012
    Posts
    7

    Regular expression pattern

    Hello,



    I am wanting to use regEx (regular expression) in visual basic code (vb6.0)

    I have one field on a form that will get inputs from a user in the following format, (note the 3 numbers of the end will

    change)
    HNPSD/001
    HNPSD/002
    HNPSD/004
    HNPSD/999
    etc

    I need the pattern/rules/constriants for this text format, so how to ensure that the HNPSD/ is always entered and that the next three digits are between 0-9.

    something along the lines of: (or i might be way off)
    eg_exp.Pattern = "^[0-9]*3"

    Thanks

    Jac

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Quote Originally Posted by jacjacjac View Post
    Hello,

    ...I am wanting to use regEx (regular expression) in visual basic code (vb6.0)...
    If this is true, why are you posting this in a forum dedicated to MS Access, instead of a Visual Basic forum?

    Linq ;0)>

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

Similar Threads

  1. class module vs regular module
    By Madmax in forum Modules
    Replies: 1
    Last Post: 05-01-2012, 03:44 PM
  2. Replies: 8
    Last Post: 03-30-2012, 06:05 AM
  3. Singleton pattern
    By joki in forum Programming
    Replies: 0
    Last Post: 05-03-2011, 09:07 AM
  4. Programming Approach for Pattern Layouts
    By IvoryDragonfly in forum Programming
    Replies: 3
    Last Post: 10-09-2010, 01:14 AM
  5. Using Regular Expression $ in Access Queries
    By rkdiekhoff in forum Queries
    Replies: 1
    Last Post: 01-20-2010, 12:50 PM

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