Formatting

  • Thread starter Thread starter Carol Shu
  • Start date Start date
C

Carol Shu

Hello.
I have a combo box in a form called "type of sale" (retail, finance,
wholesale), and 2 fileds called "cash down" & "finance fee" .
I need the "cash down" & "finance fee" fields to turn yellow if the combo
box "type of sale" has been select to "finance" .
Could you please help with this?

Thanks.
Carol Shu
 
Thank you Fred,
I'm using Access 2007, i'm sorry, i don't understand what you mean..

fredg said:
Hello.
I have a combo box in a form called "type of sale" (retail, finance,
wholesale), and 2 fileds called "cash down" & "finance fee" .
I need the "cash down" & "finance fee" fields to turn yellow if the combo
box "type of sale" has been select to "finance" .
Could you please help with this?

Thanks.
Carol Shu
Click to expand...

For Access 2000 or newer?

On your form, select the [CashDown] control.
Click on Format + Conditional Formatting
Set Condition1 to
Expression Is
Write:
[TypeOfSale= "Finance"
Select the color you want.
Save the change.
Do the same in the [FinanceFee] control.
Click to expand...
 
Thank you Fred, I got it..perfect

fredg said:
Hello.
I have a combo box in a form called "type of sale" (retail, finance,
wholesale), and 2 fileds called "cash down" & "finance fee" .
I need the "cash down" & "finance fee" fields to turn yellow if the combo
box "type of sale" has been select to "finance" .
Could you please help with this?

Thanks.
Carol Shu
Click to expand...

For Access 2000 or newer?

On your form, select the [CashDown] control.
Click on Format + Conditional Formatting
Set Condition1 to
Expression Is
Write:
[TypeOfSale= "Finance"
Select the color you want.
Save the change.
Do the same in the [FinanceFee] control.
Click to expand...
 
Back
Top