Conditional Formating

[Bob]

If there is no data , how do you do that???


Thanks in advance.........Bob Vance

 

[Ken Snell \(MVP\)]

Not sure what you're asking -- do you mean what expression or test do you
use in the Conditional Formatting for a control to test if it's empty? If
yes, select Expression Is and use this (replace generic name with actual
name of the control):

Len([NameOfControlGoeshere] & "") = 0

 

[Bob]

Brilliant Thanks Bob

Not sure what you're asking -- do you mean what expression or test do you
use in the Conditional Formatting for a control to test if it's empty? If
yes, select Expression Is and use this (replace generic name with actual
name of the control):

Len([NameOfControlGoeshere] & "") = 0


--

Ken Snell
<MS ACCESS MVP>

If there is no data , how do you do that???


Thanks in advance.........Bob Vance