Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditonally format text box on main form based on sub form check box

Status
Not open for further replies.

LD1010

Technical User
Dec 6, 2001
78
US
Is it possible to conditionally format a text box on the main (single)form based on the value of a check box on a sub form? If so how would you construct the format statement?

I've tried the following:

IIf([Forms]![sfrmSurveySent].[SurveySent]= Yes,True,False)
 
Yes. Simply.
Select: "Expression Is"
[sfrmSurveySent]![SurveySent]
 
Thanks MajP,

I've tried what you posted but it doesn't seem to work? I must me missing something.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top