Possible to "stack" column labels in a datasheet view form?

Is there a way to stack column labels in a datasheet view form like this:

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

No.  You'll have to combine the sport and Yes/No strings
Jeffrey CoachmanMIS LiasonCommented:
Expanding a bit more on aikimark's post:
(Typically one Participant can be involved in many sports and one sport can have many participants)
so this might be the next logical step in the design eveolution...

pID (PK)

psID (PK)
ps_pID (FK)
ps_sID (FK)


But we need to know a bot more about this system.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
If you want the labels stacked, you will need to use a continuous form.  You can make it look like a DS form but it won't operate the way a DS form does.  It will be fixed and unchangeable by the user unlike a DS form where you can resize columns and rows and reorder the columns.
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Jeffrey CoachmanMIS LiasonCommented:
Pat, ...but the design may still need to be refined, as it is not clear if Football:Yes, ...automatically means BaseBall=No,
...or if they can be in both
Jeffrey CoachmanMIS LiasonCommented:

As you know, the design you outlined is somewhat simplistic.
It treats Access as if it were a spreadsheet.
It will cause you major headaches if you ever need to Aggregate the sports
(How many in Baseball, ...for example)
Jeff, I was in a hurry so I decided to ignore the spreadsheet design and simply answer the question but you are correct, it does look like a spreadsheet although I wouldn't assume mutual exclusivity.  Many people play what ever sport is in season.
Jeffrey CoachmanMIS LiasonCommented:
Pat, ...yes I was unsure as well
Jeffrey CoachmanMIS LiasonCommented:
Thanks Steve, ...glad we could help.
SteveL13Author Commented:
You guys always help.  I just don't always do a great job explaining what's in my head.  (Scary place to be)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.