while typing value in filed show the user matching value in table

[Avi]

i build an application and in a form the user can add new record
while the user typing a new value in filed i want to show him values
reside in the table that match
the char's he already enter
how can i do it ?

 

[Jeff Boyce]

Avi

One approach would be to use a combo box. You can set the properties to
automatically display the first record that includes what the user has
already typed. If the user keeps typing characters, the combo box keeps
narrowing the list until either there's the one the user wants or there are
none. Have you considered how to handle a value that does NOT exist?
(hint: check the NotInList event via Access HELP for the combo box).

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Avi]

Hi Jeff
if i want to do it with text box
can you give me hint

Jeff Boyce ëúá:

 

[Jeff Boyce]

Access offers a control that will let you do that ... it is called a combo
box. I'm afraid I haven't spent any time trying to duplicate the
functionality of a combo box when it is already available.

If I had to, I'd look into creating an event procedure using the KeyPress
event to read each keystroke and react.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


Hi Jeff
if i want to do it with text box
can you give me hint

Jeff Boyce ëúá: