Trouble with conditional formatting (1 Viewer)

J

jjake

Registered User.

Local time

Today, 12:54

Joined

Oct 8, 2015

Messages

291

• May 18, 2018

• #1

Hello,

I am currently using the following code in VBA to disable/enable a text box.

Code:Copy to clipboard

DLookUp("[Department]","[tblUsers]","[UserTag]='" & [Me].[txtUser] & "'")=2

I have tried using this same expression in conditional formatting to enable a different box but it isn't working. Any idea why?

 

bastanu

AWF VIP

Local time

Today, 10:54

Joined

Apr 13, 2010

Messages

1,402

• May 18, 2018

• #2

Conditional formatting cannot disable a box, it simply changes the formatting. Try it without Me like:
DLookUp("[Department]","[tblUsers]","[UserTag]='" & [txtUser] & "'")=2

Cheers,
Vlad

 

isladogs

MVP / VIP

Local time

Today, 18:54

Joined

Jan 14, 2017

Messages

18,209

• May 18, 2018

• #3

You can easily do this in code

Code:Copy to clipboard

if DLookUp("[Department]","[tblUsers]","[UserTag]='" & [txtUser] & "'")=2 Then
Me.othertextboxname.Enabled=True
End If

Use this code in a suitable procedure e.g. The after update event of txtUser control

 

J

jjake

Registered User.

Local time

Today, 12:54

Joined

Oct 8, 2015

Messages

291

• May 18, 2018

• #4

Ridders, i currently have this textbox using conditional formatting to enable/disable using the following expression

Code:Copy to clipboard

[RDReview]=1 And [ProductionReview]=1 And [MaintenanceReview]=1 And [SafetyReview]=1 And [SiteManagerReview]=1

How would i combine this with the code you provided?

 

isladogs

MVP / VIP

Local time

Today, 18:54

Joined

Jan 14, 2017

Messages

18,209

• May 18, 2018

• #5

Just combine them like this

Code:Copy to clipboard

if DLookUp("[Department]","[tblUsers]","[UserTag]='" & [txtUser] & "'")=2 And [RDReview]=1 And [ProductionReview]=1 And [MaintenanceReview]=1 And [SafetyReview]=1 And [SiteManagerReview]=1 Then
     Me.othertextboxname.Enabled=True
End If

 

Last edited: May 18, 2018

June7

AWF VIP

Local time

Today, 09:54

Joined

Mar 9, 2014

Messages

5,466

• May 18, 2018

• #6

@bastanu, yes ConditionalFormatting can enable/disable.

I agree that Me. must be removed from the ConditionalFormatting expression.

Me. and Me! only work in VBA.