Results 1 to 3 of 3
  1. #1
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts

    Auto complete (2000, SR-1)

    Is there a way to have Access "auto-complete" a repetitive entry, when the entry is a telephone number? I have to enter phone numbers in a field, and many numbers are are repetitive. I've already slected the phone number input mask. For example, if I enter 212-555, is there a way to have Access automatically complete the entry with a previouly entered number of 212-555-1234? I set the field format as text. Thanks.
    JimmyW
    Helena, MT

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto complete (2000, SR-1)

    When entering data in a table, query or form, typing CTRL-4 (the 4 above the letters, not that of the numeric pad), Access copies the previous entered data for that field.

    Hope this help.

    Francois
    Francois

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Emerald Beach, New South Wales, Australia
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto complete (2000, SR-1)

    Use a combo box for the control with the rowsource based on a distinct list of previously enetered values.

Posting Permissions

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