Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Input mask - City (2K and XP)

    I was really happy with the input mask I wrote for "City" until I ran into cities that have two or more names.
    My input mask: >L<??????????????? (to display the name with only the first letter capitalized--Proper, y'know).

    Now...how do I modify it to work with, e.g., "Mount Crawford"? Or "James Madison University"?

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Input mask - City (2K and XP)

    Sorry - it can't be done with an Input Mask - it needs VBA
    See <!post=this thread,219160>this thread<!/post> for some ideas
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Input mask - City (2K and XP)

    Thanks a million for that tip! It worked perfectly!

Posting Permissions

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