I am trying to populate a combo box with a subset of names from an Access data base using the * character.

The Debug.Writeline text of the SQL statement I am using in the SELECT statement is:

SELECT TBLNames.Name FROM TBLNames WHERE (((TBLNames.Name) Like "Rob*"))

This SQL statement works within the Access db itself to return all names starting with Rob.

But in .NET it only returns the name, Rob*, if I force that into the db.

Can anyone help?