Conditional format (1 Viewer)

Safari

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

CJ_London

Super Moderator
Staff member
Local time
Today, 07:15
Joined
Feb 19, 2013
Messages
16,610
already a thread on this subject here
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 02:15
Joined
Feb 19, 2002
Messages
43,266
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
Today, 14:15
Joined
May 7, 2009
Messages
19,241
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