display of a combobox (should be simple..)

From: Not Me (Not.Me_at_faker.fake.fa.kee)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 14:01:27 +0100

Hi,

I have a table as a combobox's rowsource. The control source is based on
column 1 of this table, however I would like to display <at least> column 2
on the combobox when it is not selected, and <at least> column 1 in the
combobox when making a choice.
I can almost acheive this by altering the column widths, and if I set them
to 0;4 for example, it shows the second column fine. The problem is the
first column isn't shown when making a choice. If I give both columns
sufficient width, then it looks fine for selecting a value, but when
selected only shows the bound column.

So is there a way of showing more than the bound column in a selected
combobox? Am I looking at a function to alter the text in the combobox, and
would this interfere with the controlsource (i.e. if i change the visible
text will it alter the fields in the table it's based on?)

Hope you can understand that! Should be simple though :oP
Cheers,
Chris