UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Continuous Form, Any Version    
 
   
access2009eg
post Apr 3 2020, 01:30 PM
Post#1



Posts: 1,200
Joined: 19-February 08



Hello friends

I have form and subform
the subform is continuous

is there any way to change back color of any control of the subform in case contain a null value

if any control.value = null

this control back color change to red


is this possible by a button on the main form









--------------------
I would like to Thank you for your help
Go to the top of the page
 
Larry Larsen
post Apr 3 2020, 01:45 PM
Post#2


UA Editor + Utterly Certified
Posts: 24,573
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)


Hi
Are the control's bound or unbound..??
thumbup.gif

--------------------
"Time...We have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresa, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein"
H. Jackson Brown
Go to the top of the page
 
projecttoday
post Apr 3 2020, 03:23 PM
Post#3


UtterAccess VIP
Posts: 12,172
Joined: 10-February 04
From: South Charleston, WV


Did you try conditional formatting?

--------------------
Robert Crouser
Go to the top of the page
 
access2009eg
post Apr 3 2020, 04:56 PM
Post#4



Posts: 1,200
Joined: 19-February 08



Thank you so much, friends
I find the solution

CODE
Me!sub!text1.FormatConditions.Add acExpression, acEqual, "ISNull ([text1])"
Me!sub!text1.FormatConditions(0).BackColor = vbRed

--------------------
I would like to Thank you for your help
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    27th May 2020 - 06:34 AM