In MS Access 97 I have a customer database. Each record is displayed in single form view. On this, there have been 9 seperate pages (tabs) inserted so that users can select on the appropriate tab to see various details of that particular customer e.g. contact details, recent communications, service users, etc. Some of these pages contain sub-forms and some of the tabs just include text boxes. What I would like to do is if the page's sub-form or text boxes contains records, then the page caption will change colour, or alternatively, if the sub-form within the page has no records then the caption of the page will grey-out. This will save the users a lot of time clicking on and off tabs to check the contents of each one. I have read some FAQs on changing label colours but nothing about page captions. Would really appreciate a starting point for this. Thanks