Steve,

Thanks for chipping in. Unfortunately, this control does not have a .DisplayValue property as it is essentially a text box that pops a list. At the time I need to query the value of it's controlsource, the list has gone and I am essentially trying to obtain the value of it's controlsource, so that I can, using I presume, some sort of makro substitution test the value returned from the list that has been written back to the controlsource by the quickfill text box itself.

>>I have a "Quickfill" type textbox. It is bound to a Controlsource. I would like to test in say, the Lostfocus event whether the value of the Controlsource is Not Empty(). If it is not empty, I know that a selection was made from the Quicken style list. I then want to assign the value of Controlsource back to This.Value. The reason ... the Quickfill textbox displays a user friendly value in it's list but returns a code to the control source. However, as the user leaves the Quickfill box, I simply wish to display the Code in the Quickfill box instead of the user friendly description. When I set step on in Lostfocus() and test for the value of This.ControlSource, it returns "" in the Watch window. Any ideas how I can achieve my goal?
>>
>>Many thanks.
>
>You may need to use .DisplayValue and you might also have to not use the .ControlSource and assign the value programmically.
>
>Steve