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--using Initial and Middle Name (2000 & XP)

    I set up fields to identify donors for a fund-raiser. Fields include DonorFName, DonorMI, DonorLName. I set up input masks to enforce Proper Case, and I set field size for DonorMI to 2. It was really pleased with myself until I run into a dude who goes by his first initial / middle name / last name (as in J. William Fulbright, for example). Gr-r-r....

    Of course, I could just let the default settings stand and let the user key in whatever they want, but, gee whiz.... With all the really cool things you can do with Access, I'd like to make this a little more sophisticated. Any suggestions?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Input mask--using Initial and Middle Name (2000 & XP)

    Change your field width. It's never safe to assume that a person will never have more than a middle initial. Allow enough room for full middle names, since some married women use their maiden name as a middle name and you may have to deal with other variations on that theme.
    Charlotte

  3. #3
    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--using Initial and Middle Name (2000 & XP)

    Further to what Charlotte has said, if you store the full middle name, you can always extract just the initial letter if you want it. It is a good policy to make field sizes for names longer than you think you need - I've been bitten by some Sri-Lankan names running to 25+ characters! Overstating the field size a bit does not waste resources in Access, I believe.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

Posting Permissions

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