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

SteveL13
SteveL13 used Ask the Experts™
on
Is there a way to stack column labels in a datasheet view form like this:

Example
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2014

Commented:
No.  You'll have to combine the sport and Yes/No strings
MIS Liason
Most Valuable Expert 2012
Commented:
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...

tblParticipants
pID (PK)
pName
pAddress
...etc

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

tblSports
sID
sName

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

JeffCoachman
Distinguished Expert 2017
Commented:
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.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
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 Liason
Most Valuable Expert 2012

Commented:
SteveL13,

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)
Distinguished Expert 2017

Commented:
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 Liason
Most Valuable Expert 2012

Commented:
Pat, ...yes I was unsure as well
;-)
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Thanks Steve, ...glad we could help.
;-)

Author

Commented:
You guys always help.  I just don't always do a great job explaining what's in my head.  (Scary place to be)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial