Form - Format Based on Option Box

[miracleblake]

I am attempting to format a text box (continuous) based on an option box. The problem that I keep running into is that there are 90 records. When running the form and making a selection for one record, the color changes for every record. I have the following Case statement.

Select Case HandReceiptStatus.Value
Case 1
Me!Name.BackColor = 12615680
Me!intHandReceipt.BackColor = 12615680

Case 2
Me!Name.BackColor = 4210816
Me!intHandReceipt.BackColor = 4210816

Case 3
Me!Name.BackColor = 10092543
Me!intHandReceipt.BackColor = 10092543
End Select
End Sub

 

[Remou]

Have you looked at Conditional Formatting?

 

[miracleblake]

Conditional formatting will not work in this case because I am trying to base the formatting off of the selection from another box.

 

[GingerR]

Yes it will work.
Choose EXPRESSION IS

and put whatever you need, i.e.
[HandReceiptStatus] = 1

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Remou]

I don't quite get that. You can refer to another form using Expression Is:

[tt]Expression Is: [Forms]![Customers]![txtCountry]=2[/tt]

 

[miracleblake]

THe Expression Is: [Forms]![Customers]![txtCountry]=2

Worked, Thank you so very, very, very much !!!