text box color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to change the backgound fill color on a report text box based on if a field is null or not?
 
AccessSue said:
Is there a way to change the backgound fill color on a report text box based on if a field is null or not?
Click to expand...


Add code to the Format event procedure of the section
containing the text box:

If IsNull(afieldtextbox) Then
thetextbox.BackColor = <color 1>
Else
thetextbox.BackColor = <color 2>
End If

Alternatively, you could use the Format - Conditional
Formatting menu item.
 
Sue,

In design view: Format|Conditional Formatting will enable
you to alter formating dependent on a value. If you don't
have this option your version is too old. Respond with
what version of Access you are running.

Terry
-----Original Message-----
Is there a way to change the backgound fill color on a
Click to expand...
report text box based on if a field is null or not?
 
Back
Top