Hide fields using vba into a datasheet form

[gstylianou]

Hello all,

I have the following problem and I need your help:

Is it possible to hide some fields in a Datasheet using vba?
I need to do that because this form used into two different main forms as a subform and and I do not want some fields to appear in either.

Thanks in advance

 

[Gasman]

Have you tried

Me.ControlName.Visible = False
Me.ControlName.Width = 0

Belay that, only seems to work for a continuous form.

Sorry.

 

[gstylianou]

Have you tried

Me.ControlName.Visible = False
Me.ControlName.Width = 0

Belay that, only seems to work for a continuous form.

Sorry.

Hi and thanks for your help but, it does't work..

 

[Gasman]

No, I realised that when I tested it, it was on a continuous form that was made to look like a datasheet.

You could amend the source of the form for the situation on form load though.?
Do not select the fields you are trying to hide?

 

[MajP]

There are several undocumented datasheet properties. There was a good article on the internet, you may try to Google it because I cannot find it.
You can show, hide, and order columns.
Here is how to hide
https://docs.microsoft.com/en-us/office/vba/api/access.textbox.columnhidden

 

[MajP]

Here is how to order columns
https://docs.microsoft.com/en-us/previous-versions/office/developer/office-2003/aa224067(v=office.11)

If I find the article I will post.

 

[MajP]

Here is how to set width
https://docs.microsoft.com/en-us/previous-versions/office/developer/office-2003/aa224081(v=office.11)

 

[Gasman]

Last two links show 404 for me?, but all options can be found in the first link on the left.

Thank you MajP

 

[gstylianou]

Hi,

This is the solution, thanks all..!!

Forms!Products!ProductID.ColumnHidden = -1

 

[Deleted member 147267]

A user can unhide the column in datasheet view - in case that matters.