Tags: access, acolumn, create, database, excell, field, form, handle, keying, microsoft, mimics, mysql, oracle, predictive, sql, text

Predictive text field

On Database » Microsoft Access

1,658 words with 1 Comments; publish: Fri, 06 Jun 2008 08:49:00 GMT; (25046.88, « »)

I need to create a field in a form that mimics the way excell would handle a

column of text . That is when keying say t and there is already a previous

entry of Tuesday it would drill down to the comparable field. I know I can

create a lookup but the bit I cant mimic is a new entry. Excell would just

give up predictive text and make a new entry. eg t would predict tuesday but

key th and there is no pevious entry for beginning with th it will

effectively switch to record entry and add the filed to the column.

All Comments

Leave a comment...

  • 1 Comments
    • On Mon, 9 May 2005 22:46:01 -0700, "Duncaninnz"

      <Duncaninnz.ms-access.itags.org.discussions.microsoft.com> wrote:

      >I need to create a field in a form that mimics the way excell would handle a

      >column of text . That is when keying say t and there is already a previous

      >entry of Tuesday it would drill down to the comparable field. I know I can

      >create a lookup but the bit I cant mimic is a new entry. Excell would just

      >give up predictive text and make a new entry. eg t would predict tuesday but

      >key th and there is no pevious entry for beginning with th it will

      >effectively switch to record entry and add the filed to the column.

      Use a Form (*NOT* a table datasheet) to do your data entry, and - if

      this field has a defined set of values - use a Combo Box control.

      If it doesn't have a limited or limitable list of values, you can

      write VBA code in the textbox's Change event to look up the values

      which already exist - but it would be a fair bit of code and somewhat

      tricky to implement.

      John W. Vinson[MVP]

      #1; Fri, 06 Jun 2008 08:50:00 GMT