Hiding a Column (1 Viewer)

[David44Coder]

I wonder if this is possible?

DoCmd.OpenForm "frmMain", acFormDS, , WhereClause


    With Forms![frmMain]
        .OrderBy = "[MyID], [iCost]"
        .Hide [A Column called iTemp] <<<<<<<<<<<<<<<<
        .OrderByOn = True
        .ShortcutMenu = False
    End With

There is no .Hide but perhaps called something else?
Other that that I found
Set fld = dbs.TableDefs!Products.Fields!ProductID
fld.Properties("ColumnHidden") = True
But not sure how to use that in my With-End With block.

 

[The_Doc_Man]

In Access, you can't REALLY hide a column in a form, but you can make it have .Width = 0. Just as good unless you wanted to keep the column header but not the column's data.

 

[David44Coder]

Thanks Doc_Man That would be fine as the header isn't needed. But having some difficulty getting it to work, although no errors are reported, it just stays the same width.

DoCmd.OpenForm "frmMain", acFormDS, , WhereClause
With Forms![frmMain]
        .OrderBy = "[MyID], [iCost]"
        .Controls("iTemp").Width = 0
        .OrderByOn = True
        .ShortcutMenu = False
    End With

 

[isladogs]

You can hide a column in a datasheet form.
Put code like this in the Form_Load event

Me.ControlName.ColumnHidden=True

Or if you want to use a With...End With block

Private Sub Form_Load()
With Me
    .ControlName.ColumnHidden = True
End With
End Sub

 

[KitaYama]

myFieldname.visible=False is not enough?

 

[isladogs]

ColumnHidden =True only works with datasheet forms. Visible =False works with any type of form

 

[David44Coder]

Thank you Colin, that worked treat. First in Form Load, then in my existing With-End With block which calls the Form and where the column is wanted hidden (conditionally).
I had actually almost got there, but when the controlName did not appear in the dropdown, assumed it was a dead end.

 

[isladogs]

You're welcome