Re: [MSAccessProfessionals] Change background color

Bingo,  good idea.  I forgot that was there.

 

Thanks,

 

Bill

 

Bill Singer

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Paul Baldy
Sent: Thursday, November 30, 2023 11:58 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Change background color

 

You can use Conditional Formatting with "Expression Is" testing the combo, or code in the format event of the section containing the textbox.

 

Paul

 

------ Original Message ------

From: "Bill Singer" <Bill.Singer@at-group.net>

To: MSAccessProfessionals@groups.io

Sent: 11/30/2023 9:39:53 AM

Subject: Re: [MSAccessProfessionals] Change background color

 

 

 

I am using equation this in the source field to change a text box on a Report based on a selection in a previous form

 

=IIf([Forms]![f_PremCollFormSetup]![cboNewPlan]=1,"X","")

 

It work fine, but rather than an X in the text box, I would rather turn the background of the box black so it stand out more.

 

I have not been able to figure out how to change the background property of a text box.

 

Any help would be appreciated.

 

Thanks,

 

 

Bill

 

Bill Singer