Subform Datasheet View

[bunji]

I have a subform that is in databsheet view. When the user logs in to the db it sets the global variable with the group level they have.

I would like a column to be hidden for a certain group of users and have tried the following.

On the subform opening event i have

if vlevel = "engineer" then

me.Hours.columnhidden = True

Else

me.Hours.columnhidden = False

End If

And i have done the same on the Main Form open event identifying the subform by Form!Subform![Hours].columnhidden = True

But neither worked.

Can any suggest something.

 

[alastair69]

try Me.hours.Visible = False

 

[bunji]

I tried that and it also did not work.

 

[bunji]

I tried that and it also did not work.

 

[Pat Hartman]

Since .ColumnHidden is a property of the control rather than the table field, make sure you are using the correct name. If the control's Name property is different from its ControlSource, you must use the control's Name property when referring to properties of the control.