Changing Color of tab/background when record is complete

E

Esch

I'm creating a Drawing Checklist that asks 23 questions, and choosing 3 list
box answer choice: N/A, YES, NO, a Comment must be included (NO only). I
have chosen to use a tabbed form for each Drawing, with 23 tabs, one question
on each tab with a large blank comment (memo field) section. I have three
questions: I want to be able to change the color of the tab when any choices
have been selected (if the user comes back to the form he/she can see where
he left off), I would also like to hide the comment field unless No is
chosen in the list box. I would appreciate any input or help. Thanks in
advance.
 
A

Arvin Meyer MVP

I don't think you can do this with an Access tab control. The backcolor is
not a property of a tab control. I wrote an Article in Access Advisor
several years ago discussing how I make custom tabs using labels and boxes.
You may want to have a look:

http://msaccessadvisor.com/doc/13961
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dlookup table/form problem 2
Tab pages: How to change background color 3
2007 Access Combo Box changes Background color after tab through f 6
Changing Text Box Color on a Form 1
Automatically select in a sub form by a number chosen in the main 1
Pop-up form when a certain value is chosen 0
Width of a tab 1
Tab control references 3

Top