Yes you can in Access 2007+
It pays to develop at the small resolution and you need to deploy Anchoring and Continuous Forms rather than datasheets. Let's take an Standard Form - I have tried Arrange > Stacked but this was an awful mess so I basically look at each form and decide what I want to expand and unfortunately this can lead to overlapping controls, Access not not adhere to the concept of Float, so I have ended up being conservative.
Continuous Forms only allows 1 Control to be expandable (Horizontal Anchoring=Both) any control preceding this control will be anchored to the left and following anchored to the right.
The areas that works well is TabControls and subForms, providing there is something to expand, the subForm will use the remaing space both horizontally and vertically if required.
The way to test Anchoring is to enlarge the Navigation Pane and see what happens horizontally.
I only use Continuous Forms and Anchoring "you have accept the limitations"
Simon