>>I believe I found the problem. The RowSource of the combo is a SQL of SELECT Projnum, Projdesc ....
>>
>>On a hunch I changed it to SELECT STR(Projnum,4), Projdesc ...
>>
>>I'm not sure why, but in the textbox portion of the combo it gets 'confused' when dealing with a numeric value and incremental search. The other interesting thing I found with this is that, with my change, the column that is used for the choice is a string while the ControlSource is still a numeric field. However, no problem, the selected 'number' went into the field fine.
>
>That's because you use VFP5 (i guess) with BoundTo property. In VFP3 you would get into troubles here.
I guess I was lucky the first few times while testing because this didn't fix the problem. What I ended up doing was setting the style to a DropDown Combo and in the Valid i put:
IF THIS.ListIndex=0
WAIT WINDOW "Project number entered is invalid" NOWAIT
RETURN .F.
ENDIF
This works great. However, now the value doesn't fit heightwise in the combo. I have the BorderStyle set to 0=None. Do I need to set something else? My FontSize is already at it's smallest value so that property is not an option.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.