Hide a page tab on form using VBA for current user

[Tor_Fey]

Good Day All;

I am looking to hide page tabs on my form for a current user; I have tried the following 'onload' event:

If Me.loggedon = jblog Then
Me.TabCtl6.Pages(0).Visible = False
End If

Please not: the field: 'loggedon' is an unbound text field which source is set to =currentuser()

The above code doesn't work, the tabs are always showing regardless, if someone could point me in the right direction on this matter; it would greatly be appreciated. :banghead:

Regards
Tor Fey

 

[Uncle Gizmo]

Try:-

 If currentuser() = jblog Then
Me.TabCtl6.Pages(0).Visible = False
End If

Sent from my SM-G925F using Tapatalk

 

[Tor_Fey]

Hi Uncle Gizmo;

Thanks for the reply, unfortunately I have tried this code and it doesn't seem to work either? Is there any other way of doing this?

Regards
Tor Fey

Try:-

 If currentuser() = jblog Then
Me.TabCtl6.Pages(0).Visible = False
End If

Sent from my SM-G925F using Tapatalk

 

[Uncle Gizmo]

Instead of "currentuser()" try a known value in the list in "jblog" and see what results you get

 

[missinglinq]

What is jblog? If it's a user name it probably needs to be in Quotes, i.e.

"jblog"

Linq ;0)>