Conditional format (1 Viewer)

Safari

Member
Local time
Today, 21:08
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, 12:08
Joined
Oct 29, 2018
Messages
21,454
Can you show us your CF expression?
 

CJ_London

Super Moderator
Staff member
Local time
Today, 20:08
Joined
Feb 19, 2013
Messages
16,609
already a thread on this subject here
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 15:08
Joined
Feb 19, 2002
Messages
43,231
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, 03:08
Joined
May 7, 2009
Messages
19,229
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