List Box on Datasheet Form

[PaulDonn]

I have a subform, that is part of a booking system, that is viewed in
datasheet view. On the form is a list box that should display a list
of current course a student is enrolled on. The list box has two
columns, 1: Course ID 2: Course Name - column one is the bound
column. The problem I have is when the form is opened only the Course
ID is displayed whereas I would like only the Course Name to be
displayed instead. I have column count set to 2 and have tried setting
the first column width to 0cm, but with no joy. I have also tried
moving the positions of the fields in the underlying query, but again
with no success.

Any help or ideas would be appreciated.

I am using Access 2002.

Thanks

[Wayne Morgan]

To the best of my knowledge, what you're trying to do won't work in
Datasheet View, you'll need to use Continuous Form View.

--
Wayne Morgan
MS Access MVP
"PaulDonn" <pa************@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

I have a subform, that is part of a booking system, that is viewed in
datasheet view. On the form is a list box that should display a list
of current course a student is enrolled on. The list box has two
columns, 1: Course ID 2: Course Name - column one is the bound
column. The problem I have is when the form is opened only the Course
ID is displayed whereas I would like only the Course Name to be
displayed instead. I have column count set to 2 and have tried setting
the first column width to 0cm, but with no joy. I have also tried
moving the positions of the fields in the underlying query, but again
with no success.

Any help or ideas would be appreciated.

I am using Access 2002.

Thanks

[PaulD]

Ah, well - thanks for the reply anyway, Wayne. Time to try another approach.

Cheers

"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:<EJ*******************@newssvr30.news.prodigy .com>...

To the best of my knowledge, what you're trying to do won't work in
Datasheet View, you'll need to use Continuous Form View.