Conditional format (1 Viewer)

Safari

Member
Local time
Today, 19:11
Joined
Jun 14, 2021
Messages
95
Hi All

How to make textbox ( bound ) enabled by conditional format with anther unbound textbox?

I made expression by if statement but its not working..
 

theDBguy

I’m here to help
Staff member
Local time
Today, 10:11
Joined
Oct 29, 2018
Messages
21,485
Can you show us your CF expression?
 

CJ_London

Super Moderator
Staff member
Local time
Today, 18:11
Joined
Feb 19, 2013
Messages
16,627
already a thread on this subject here
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 13:11
Joined
Feb 19, 2002
Messages
43,331
This code needs to be executed from at least two different events - the form's Current event and the textx's AfterUpdate event
Code:
If Me.textx > 0  Then
    Me.xx.enabled = True
Else
    me.xx.enabled = False
End If
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:11
Joined
May 7, 2009
Messages
19,247
private sub textx_afterupdate()
Me!xx.Enabled = (Nz(Me!textx, 0) <> 0)
end sub

private sub form_current()
call textx_afterupdate
end sub
 

Users who are viewing this thread

Top Bottom