Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Apr 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Social Security Fields in Word (Xp)

    Is there a field for ###-##-#### in word or is that ONLY in excel? Thanks

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Social Security Fields in Word (Xp)

    Can you give a little more detail about how you would enter this information? For example, if you are putting information into an ordinary table cell, there is no such thing as a "numeric picture" format for just a plain table cell. On the other hand, if you are creating a Word form using form fields from the Forms toolbar, you might have more options. And if you are creating a Userform using the VB Editor, still other options.

  3. #3
    New Lounger
    Join Date
    Apr 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Social Security Fields in Word (Xp)

    I have my info in an ordinary table as it is part of a Word document, but if I can create a Word form using the form fields instead, I am interested in knowing how. Thanks.

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Social Security Fields in Word (Xp)

    Hi gogetter,

    If you insert a formfield and set its properties to 'number', you can set the default number as '0000-00-0000' (without the quote marks), the maximum length as 12 and define a custom number format using '####-##-####' (also without the quote marks). Note that omitting a number, including a leading 0, will give a result in which the trailing portion of the field is truncated - replacing the #s with 0s on the right end of the field format doesn't correct this.

    For privacy and other reasons, it's often thought that the full SSN shouldn't be input or output. This may/may not be an issue for you. Often, just the last 4 digits are used.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Social Security Fields in Word (Xp)

    if the question was related to securiy, then a textbox could be placed on a userform and the textbox's passwordchar property could be set to, say, # or * and that will hide what the user types.

Posting Permissions

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