By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,148 Members | 774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,148 IT Pros & Developers. It's quick & easy.

How can I change the back colors of the all records

100+
P: 222
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
Oct 21 '08 #1
Share this Question
Share on Google+
3 Replies


P: 26
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.
Oct 22 '08 #2

100+
P: 222
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
Oct 22 '08 #3

NeoPa
Expert Mod 15k+
P: 31,494
TextBox & ComboBox controls both have .FormatConditions collections. You can use code to add items to the collections for each control you need.
Oct 27 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.