John,
In Datasheet view, your restricted to just one line of header text.
You can however design a form that looks just like a datasheet view, but would allow
column header labels of more than one line.
I just created the header in Excel and copy and paste it to Access Form and then go to the outline view to align the table that I created with the form header, it looks like this now: