Solved

Conditional formatting

Posted on 2011-02-24
3
351 Views
Last Modified: 2012-05-11
Hi,
I want to use the conditional formatting in access to highlight records in a subform. The subform default view is Continuous Forms. The conditional format is set to field PERSNUMBER.
This field is stretched over the entire width of the form.
The backstyle of PERSNUMBER is Normal, all the other fields are set over the field PERSNUMBER in frontposition and the backstyle is transparant.
When i open the form and i select PERSNUMBER then the whole line disapear and get the color of the conditional formatting.
What i'am doing wrong?

Tx
0
Comment
Question by:sonmic
3 Comments
 
LVL 84
ID: 34970027
So when your CF fires, you see the color that you've set for the PERSNUMBER field, and you cannot see your other fields?

Are you absolutely sure that you have enforced that PERSNUMBER is set to "Bring to Front"?

Other than that, you might consider setting the CF values in each of your controls to format the BackColor of those controls.
0
 

Author Comment

by:sonmic
ID: 34972419
All the other fields are set to front.
I used the following website.
http://datapigtechnologies.com/flashfiles/accesscondformatting1.html
0
 
LVL 3

Accepted Solution

by:
DockieBoy earned 500 total points
ID: 34972931
As soon as you set the focus to that control it will be brought to the front and the other text boxes not visible.  Set that control to locked = Yes and Enabled = No.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question