Table1.FindNearest([edit1.text]);

it only shows the actual data if I write in the whole value to be found.  If I enter only partial values, the scroll bar shows that a record was found, but it doesn't display.  How do I get it to display?

A:  The answer is that it DOES display.  Because of the way that the value is evaluated, you should pad the string with zeros to the size of the (in this case) CustNo.  (CustNo is a number field.  If you enter a partial value, it is seen as a lower value number.)