Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010
    Location
    California
    Posts
    8

    Unanswered: Auto complete text

    I have a table containing a list of items that start with a number and then have text such as (4000 Utility Expense). I also have a query that asks to enter a number from the list. When entering an item I would like to enter the number and have the text portion automatically completed. Is this possible?

    Geno

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    It is not clear enough what do you exactly want. Be more precise.
    Last edited by MStef-ZG; 11-09-10 at 03:39.

  3. #3
    Join Date
    Nov 2010
    Posts
    8
    It would certainly be possible if the text and number were in different fields in your table. The query could then be instructed to look up the text and concatenate it. Depending on your end use (for example in a form, datasheet etc) it may be slightly different how you'd do it but it should be a fairly simple expression along the lines of [number typed] & " " & [text field from original table]

Posting Permissions

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