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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formating a Textbox in report... 2
Change text box background color depending on value in Label Reports 1
Report Background Color 4
Make a text box fit the value inside 4
Report Can Grow not aligned horizontally 2
Excel Macro to automatically go to the right of the last colored cell 0
Rich Text Format 0
Dcount the values 0

Back
Top