Combo Box only shows One Field

[DanAuber]

I have a combo box on a form with 3 columns in it when it lists the options - however when an option is actually selected - the form only displays column one. Is there any way to change this

Any help gratefully received
[sig]<p>Dan Auber<br><a href=mailtoanAuber@aol.com>DanAuber@aol.com</a><br><a href=

http://members.aol.com/_ht_a/danauber/myhomepage/>Dan

Auber's Home Page</a><br> [/sig]

 

[Phooey]

Hi, Dan

Have a look a thread181-28856
hope this helps... [sig]<p>Phooey<br><a href=mailto:Andrew.j.harrison@capgemini.co.uk>Andrew.j.harrison@capgemini.co.uk</a><br>Otherwise known as Windy Bottom.[/sig]

 

[DanAuber]

Phooey,

thanks that is a pretty decent workaround.
If I want to make sure that each cloumn begins at the same point - so I get:

Auber Dan
Smith John

and not

Auber,Dan
John,Smith

I would use RPAD in Oracle - any idea what Access's equivalent is ?? [sig]<p>Dan Auber<br><a href=mailtoanAuber@aol.com>DanAuber@aol.com</a><br><a href=

http://members.aol.com/_ht_a/danauber/myhomepage/>Dan

Auber's Home Page</a><br> [/sig]

 

[Phooey]

Unfortunatwely, I don't know that one off the top of my head except by using fixed length fields..

I.e. pad each value out with spaces but that would only work in monospaced fonts. [sig]<p>Phooey<br><a href=mailto:Andrew.j.harrison@capgemini.co.uk>Andrew.j.harrison@capgemini.co.uk</a><br>Otherwise known as Windy Bottom.[/sig]

 

[DanAuber]

Thanks anyway [sig]<p>Dan Auber<br><a href=mailtoanAuber@aol.com>DanAuber@aol.com</a><br><a href=

http://members.aol.com/_ht_a/danauber/myhomepage/>Dan

Auber's Home Page</a><br> [/sig]