开发者

Access subform in a split view parent - hide from datasheet section

开发者 https://www.devze.com 2023-04-04 01:28 出处:网络
I have a split view form with a subform in it. In the data开发者_JAVA技巧sheet part of the split view Access displays a plus (+) that allows the user to display the subform for that record.

I have a split view form with a subform in it. In the data开发者_JAVA技巧sheet part of the split view Access displays a plus (+) that allows the user to display the subform for that record.

I want to prevent this behavior. How can I hide the subform from the datasheet section, but not the form section?

Even when all the subform columns are hidden the plus remains, even though it expands to show an empty subform.

Can the datasheet section be handled independent of the form view?


Try changing the table (split form's recordsource) properties (see picture below).

This may not be ideal solution since it will affect all forms (with datasheet views) that are based on the underlying table, though.

Access subform in a split view parent - hide from datasheet section


  1. insert new (blank) subform (set visible NO)
  2. set it lowest Tab Order among subforms (must be the first)

plus sign disapears

0

精彩评论

暂无评论...
验证码 换一张
取 消