Split View

[kitty77]

I created a form with a split view. Is it possible to only show a few fields on the table view and more fields in the detail area?

 

[isladogs]

Not possible using a standard split form as it is just one form - check in design view.
However that would be possible using an emulated split form:

Emulated Split Form

The emulated split form was created as a project to overcome the difficulties inherent with the built-in split form supplied with Access

www.isladogs.co.uk

 

[theDBguy]

I seem to vaguely recall a similar discussion. Have you tried hiding the columns you don't want to see in the datasheet view?

 

[theDBguy]

Like this?

Table

Split Form

 

[isladogs]

Apologies. DBG is correct.
You need to display all required fields then hide the unwanted fields in the datasheet view

However, you can't do it the other way round...as the single view is the 'parent' part of the split form.
Removing fields from the single form section removes them from the datasheet as well

 

[kitty77]

So, it looks like hiding is the way to go?

 

[theDBguy]

So, it looks like hiding is the way to go?

It's all I can think of...

 

[kitty77]

Thanks!

 

[theDBguy]

Thanks!

No worries. @isladogs and I are happy to assist. Cheers!