list box to verify data entry-can't stop auto trailing entry inclu

G

Glenn & the dogs

Table Data3
Env_no number list box , table/query, row source
personal
info by alphabet
Date date/time
Designation text
Contribution currency

Table Personal info
Env_no number
L_name text
F-name text

Range of env_no is 0 to 1000
Problem is that when I start to type 3 in table Data3 it shows 399 in
listbox if I next type 0 the list box shows 305 if I then type "spacebar"
the list box shows 30

When entering data quickly I would like it to show only digits actually
typed (and stored when "return Key" is hit) but allow me to mouse click the
list box to verify Env_no is correctly assigned to correct person

-- Thanks Glenn
 
J

John W. Vinson

Table Data3
Env_no number list box , table/query, row source
personal
info by alphabet
Date date/time
Designation text
Contribution currency

Table Personal info
Env_no number
L_name text
F-name text

Range of env_no is 0 to 1000
Problem is that when I start to type 3 in table Data3 it shows 399 in
listbox if I next type 0 the list box shows 305 if I then type "spacebar"
the list box shows 30

When entering data quickly I would like it to show only digits actually
typed (and stored when "return Key" is hit) but allow me to mouse click the
list box to verify Env_no is correctly assigned to correct person

-- Thanks Glenn
Click to expand...

Make the EnvNo a Text field instead of Number; and set the list box's Auto
Complete property to No (and Limit to List to Yes).

John W. Vinson [MVP]
 
Top