Hide + column in Datasheet

[NevilleT]

I have a form and subform which I want to view as a datasheet for quick
scanning purposes, Once I find the record I want, I double click a field
which runs
DoCmd.RunCommand acCmdFormView
Is there any way to hide the + sign indicating child records in the datasheet?

 

[John W. Vinson]

I have a form and subform which I want to view as a datasheet for quick
scanning purposes, Once I find the record I want, I double click a field
which runs
DoCmd.RunCommand acCmdFormView
Is there any way to hide the + sign indicating child records in the datasheet?

Set the Query's Subdatasheet property to None (by default it's Auto).

 

[NevilleT]

Hi John

Thanks for the advice but I am missing something. I can expand a
subdatasheet, and I see from help that I can remove it but how do I set it to
none? I want to do it in VBA rather than manually.