By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,345 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,345 IT Pros & Developers. It's quick & easy.

List Box on Datasheet Form

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.