Hide + column in Datasheet

  • Thread starter Thread starter NevilleT
  • Start date Start date
N

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?
 
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?
Click to expand...

Set the Query's Subdatasheet property to None (by default it's Auto).
 
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.
 
Back
Top