How can I change the back colors of the all records

[wassimdaccache]

Hello

I have a continuous form that contains 10 fields. Just one field is enable and other are disabled.

User is able to navigate records using the arrows keys on the keyboard.

I am using conditional formatting option to change the back color of the record that has the focus.

What I would like to do is to change the back color of the whole records.

I already know that I can do it using VB code but the problem is that I have 200 forms and each one contains (10 to 15 fields).

Is there anyway by access option or database option?

Any method to optimize my idea would be appreciated.

Thank you in advance.


WASSIM S DACCACHE

[jayjayplane]

Sorry, I can't help, but would you like to share the code to change the back color of the whole records, I am also working on this part, but I don't know how.

Also help you keep the post up.

[wassimdaccache]

Sorry, I can't help, but would you like to share the code to change the back color of the whole records, I am also working on this part, but I don't know how.

Also help you keep the post up.

Find this sample it might be helpful for you. It is not my code I found it using Google. I understood it well but I am almost sure that exist other simple method.

SELECT THE WHOLE RECORDS

Wish to get some feedback for other method

REGARDS.

WASSIM S DACCACHE

[NeoPa]

TextBox & ComboBox controls both have .FormatConditio ns collections. You can use code to add items to the collections for each control you need.