back color

[kitty77]

What is the best way to say this...

I want the back color of a field if not null to be yellow, otherwise the back color will be white. The field name is [memo]

Thanks!

 

[theDBguy]

Back color as displayed where, exactly? Table or Form or something else?

 

[kitty77]

Sorry, onload of a report.

 

[arnelgp]

use conditional format.
Expression is:
IsNull([memo]) = False

 

[kitty77]

How does that address the back color?

 

[kitty77]

I would rather use VBA instead.

 

[The_Doc_Man]

This field will either be represented by a control in a header, a footer, or the detail section. To use VBA, you need to find the OnFormat event for that section. However, if the control actually exists in the section, I don't think it is possible for the backcolor to be null. I.e. if the control exists, so does its backcolor. It might be zero (which is equal to vbBlack). Assuming the control name is Memo1, you might have this line in the event code:

If NZ( Me.Memo1.Backcolor, 0 ) = 0 Then 
    Me.Memo1.Backcolor = vbYellow
Else
    Me.Memo1.Backcolor = vbWhite
End If

or something similar to that.

 

[arnelgp]

I would rather use VBA instead.

code in VBA will only be "seen" on Print Preview (and not on Report view).
if you use Conditional Format, it will be "seen" on both views.
see sampleReport in this demo.
on design view click on memo textbox and check the Conditional Format on the Ribbon.

 

[kitty77]

code in VBA will only be "seen" on Print Preview (and not on Report view).
if you use Conditional Format, it will be "seen" on both views.
see sampleReport in this demo.
on design view click on memo textbox and check the Conditional Format on the Ribbon.

Perfect!!!