Conditional Formatting row on form where the user is typing (1 Viewer)

[access2010]

I would like to have the row on our form where the user is typing to have a Background Colour as chosen by Conditional Formatting.

Attached is what I have tried without success.

Could I please be advised as to what I have done wrong?

Have a happy holiday.
Betty

 

[CJ_London]

1. you need to include an autonumber field in your table called investmentID
2. the control you want to conditionally format needs to be bound to investmentID (you can hide the text with conditional formatting)
3. you need to include the following code in your form current event
txtlink=investmentID

 

[Galaxiom]

I have not looked at the file but the key to as-you-type is to use the "Expression Is" ConditionalFormat condition and the Text Property of the Control.

Text is what you are typing as opposed to Value, which is the current value.

 

[access2010]

1. you need to include an autonumber field in your table called investmentID
2. the control you want to conditionally format needs to be bound to investmentID (you can hide the text with conditional formatting)
3. you need to include the following code in your form current event
txtlink=investmentID

Thank you for your note, CJ London.
I think that I have done what you suggested, but the Row Background Colour is not changing.
When you have an opportunity could you please update the attached database for me?
We are using MsAccess 2003.
Enjoy your holidays.
Betty