Background row colour not working. (1 Viewer)

[access2010]

In the our form = Expression, the Background Colour for each row is working.

Could you please advise me how we can obtain the background row colour for the form = Investments_StockBrowse_F_As_Report, as we have had no success.

Your assistance will be appreciated in assisting us with this Access 2003 form.

Thank you.
Nicole

 

[June7]

Exactly what is the issue? What should happen and what does happen?

Are you aware that using VBA to set properties will show the same result for ALL instances of control, not just the current record?

Strongly advise not to use spaces nor punctuation/special characters (underscore is only exception) in naming convention.

 

[access2010]

Thank you June7, for your question.

In the form = Expression = as you move the Cursor down the page, the background colour for the ROW that you are at CHANGES and this is what we would like to happen in our form = Investments_StockBrowse_F_As_Report = and the other forms which we have.

Thank you.
Crystal

 

[mike60smart]

Thank you June7, for your question.

In the form = Expression = as you move the Cursor down the page, the background colour for the ROW that you are at CHANGES and this is what we would like to happen in our form = Investments_StockBrowse_F_As_Report = and the other forms which we have.

Thank you.
Crystal

Hi Crystal

See the attached.
The effect is achieved by using Conditional Formatting on an Unbound Textbox.

 

[access2010]

Mike60Smart, P.E.R.F.E.C.T.

Thank you, for your database and for fixing our problem.

We have incorporated your code in our other forms which, all now work.

Regards,
Nicole