Hide Field/Column in SubForm in Datasheet View

[Joe4]

I have a subform which I am attaching to a main form. The subform is in datasheet view. I would like to "hide" the field (which appears as a column in datasheet view) that is used to link the subform to the main form, as the field is redundant and takes up unnecessary room on the subform view. In the subform, I went to the properties of this field and changed the Visible property to "No", but it still shows up.

Is there some trick to hiding this column when displaying the subform in datasheet view? I don't think I can remove it altogether, as it is my linking field. In the interim, I have moved this field to be the last field to the right on my subform, but I would love to not display it at all.

By the way, I am using Access 2007.

Thanks

 

[boblarson]

Joe -

You need this:
http://msdn.microsoft.com/en-us/library/aa217449(office.11).aspx

(it works with versions 2007 and 2010 as well)

 

[alansidman]

Joe,
I wasn't able to test this in 2007 but in 2002 it worked. I opened a form in datasheet view and right clicked on the column I wanted to hide. It offered a hide selection. I clicked and the column (field) was hidden. Closed the Form and re-opened. Still hidden.

Alan

 

[Joe4]

Bob,

Thanks! That had exactly what I needed. His code is a lot more complex that what I need (he is hiding multiple controls by looping through them), but I gleaned what I need:

Private Sub Form_Load()
    Me.FieldName.ColumnHidden = True
End Sub

Alan,

Out of curiosity, I looked into your suggestion too. I wasn't seeing the hide option until I right clicked on the column name (instead of a cell in the column). It looks like that might work too. The only question I wonder is how hard it is to un-hide it in the future, if you ever need to (if it is hidden, I am not sure how you would click on it to unhide it!).

Thanks for the help. Good stuff!

 

[Norie]

Perhaps it's a 2010 thing but I was able to create a linked form/subform setup with the subform being a datasheet with the linked field hidden.

 

[Norie]

Just saw the other responses.

To unhide just right click and select Unhide, you should get list of all the fields with checboxes for hide/unhide.

 

[alansidman]

Joe,
Just got back. Norie has the answer. Right click.

Alan

 

[Joe4]

Good to know. Thanks everyone!

 

[boblarson]

Joe,
Just got back. Norie has the answer. Right click.

Alan

The simplest by far. One other way would be to provide a button on the Ribbon to iterate through the fields and ensure that all of the ColumnHidden are set to False.