Hiding an Index on a datasheet form

bknight
BronzeLounger
Posts: 1389
Joined: 08 Jul 2016, 18:53

Hiding an Index on a datasheet form

Post by bknight »

I have tried hiding the index on a form, and this has been done before but I can't remember where to effect change. I keep getting a "you can't hide a control that has focus".

User avatar
HansV
Administrator
Posts: 78475
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Hiding an Index on a datasheet form

Post by HansV »

Open the form in datasheet view.
Right-click the header of the index field.
Select Hide Fields from the context menu.
Close and save the form.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1389
Joined: 08 Jul 2016, 18:53

Re: Hiding an Index on a datasheet form

Post by bknight »

Where is "Context Menu"
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78475
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Hiding an Index on a datasheet form

Post by HansV »

I wrote: "Open the form in datasheet view."
Your screenshot shows the form in design view.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1389
Joined: 08 Jul 2016, 18:53

Re: Hiding an Index on a datasheet form

Post by bknight »

You're correct, thanks for correcting me.