General information
Category:
Coding, syntax & commands
>Sneaky Solution - if your data field is a 2 character code, you can always do a query in the form Code + ' - ' + Description
and use a 2 character wide ControlSource that just takes the first two charactewrs into account...
I think because if you bind a combo with longer strings to a field thats shorter, you get a blank (I don't remember if it was stored as blank, or it just showd that way), either way, you don't have to be that sneaky about.
Just select the Code and the Description together (that way you can incremental search on Code like he wanted and still diplay the description) plus the second column which is just the code, and set BoundColumn to 2.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only