Not autofind in the description (1 Viewer)

[hfsitumo2001]

Hello,
I noticed that any supplies description of our supplies starting with "#", e.g "#15 Citra Cide" This will not be auto find, so we have to scroll down and search on the combo window. Anyone can help me why, and how can we solve the problem?.

Thank you

Frank

 

[GPGeorge]

Is it true that ALL descriptions start with the pound sign? Or that SOME of them do?

You can eliminate the first character from the comparison by using Mid()

You mention combo window, so I assume this is referring to the row source for a combo box.

If the first case is true, you could try this.

SELECT SupplyItemID, Mid([SupplyDescription], 2)
FROM tblSupplyItems
ORDER BY Mid([SupplyDescription], 2)

However, if some descriptions do not have the pound sign in the initial position, the task could be harder.
What is the situation?

 

[MajP]

Not sure if you can fix that for a standard combobox.
You could turn it into a Find as You Type combobox and it will work. I just tested. So when you type # it not only goes to the first # but also filters the choices to only ones with #. I have a class module that you can load to turn any combo into an FAYT combobox.

Find as we typed

Part of my form is to enter customer's info based on Combo Box. My combo is working if we type the beginning part of the customer name. How can we make it even 3 characters in the middle of the name, can auto find the closest names?. If any sample of database, could you uploaded it here please...

www.access-programmers.co.uk

 

[hfsitumo2001]

However, if some descriptions do not have the pound sign in the initial position, the task could be harder.

Yes the situation is not all the supplies description have the starting #

Thank you,

Frank

 

[hfsitumo2001]

You could turn it into a Find as You Type combobox and it will work.

I already have find as you type but still not work.

Thank you,

Frank

 

[MajP]

I already have find as you type but still not work

Must not have good code then. Works as described!