undo conditional format.

[John Sh]

In the form below, I have manage to set the format of a row where the accession number is 0 to this yukky green.
How do I undo this.
I have tried highlighting the columns with "Ctrl" in the layout view and was able to fix the "JPG Image" column but can't go any further.
There are separate conditions on some columns and I would like to keep these, if possible.
Highlighting multiple columns shows no condition set.

 

[GaP42]

You said

I have manage to set the format of a row where the accession number is 0 to this yukky green.

Did you do this as a conditional format rule? If so why can you not remove the rule?
If it is not a conditional format rule how did you set it?
Are the other separate conditions on some columns set in the same manner?

 

[John Sh]

You said

Did you do this as a conditional format rule? If so why can you not remove the rule?
If it is not a conditional format rule how did you set it?

I made this form some years ago and have no idea how I set the condition. When I selected the first two columns there was a condition thatt I removed and that fixed column2. There is no code on the form to do this.

Are the other separate conditions on some columns set in the same manner?

The conditions on the other columns are set using conditional formatting and I have no problem modifying those.
There is no rule, that I can find, that would be controlling the entire row.
As you can see, the rows where "Accession number" is greater than 0 are not affected.
I should add that my knowledge of vba was even less then than it is now, so I probably found the method on this forum.

 

[The_Doc_Man]

I can't tell by looking, so if this is wrong-headed, it's just me throwing a dart at the dartboard. You say you have that yecchy green color. You also have a set of conditional formats. But in the case where NONE of the conditions apply, what is the static background color of the field (propery name .BackColor)? and is there a chance that instead of that, you are looking through a no-color transparent field to see the back color of the form's section?

 

[John Sh]

I can't tell by looking, so if this is wrong-headed, it's just me throwing a dart at the dartboard. You say you have that yecchy green color. You also have a set of conditional formats. But in the case where NONE of the conditions apply, what is the static background color of the field (propery name .BackColor)? and is there a chance that instead of that, you are looking through a no-color transparent field to see the back color of the form's section?

I'm not quite sure but I think yes and no but not necessarily in that order.
The backcolor is a light grey, rgb(231,230,230)and the controls are rgb(255,255,255)
Here is the form and a section of the table.
Much of the functionality of the form relies on code in modules but you will get the idea.
John

 

[MajP]

I will show you what the Intent Is. The intent is that this highights the selected row. But it needs a unique ID. I assume someone modified this form and bound TxtAcctNo to the wrong field.
It need to be bound to the Primay Key for that record. A unique value.

 

[John Sh]

I will show you what the Intent Is. The intent is that this highights the selected row. But it needs a unique ID. I assume someone modified this form and bound TxtAcctNo to the wrong field.

Hi MajP.
I am unable to open your db as Microsoft has blocked it for some ridiculous reason about macro's and with no way of letting the file run..
You have, however, made me realise that it is doing exactly what it was meant to do, highlight a row where txtaccno is 0.

 

[MajP]

You have, however, made me realise that it is doing exactly what it was meant to do, highlight a row where txtaccno is 0.

That is not what it is doing. It highlighting all rows that have the same txtaccno as the current row. If you select another row without zero it will high light those.

 

[John Sh]

That is not what it is doing. It highlighting all rows that have the same txtaccno as the current row. If you select another row without zero it will high light those.

With the exception of "0" which signifies no data entry even though we have an image of the specimen, all other txtaccno numbers are unique.
The table behind this form is built from data extracted from 12,000 odd raw files and a similar number of jpg images for the express purpose of highlighting errors in our data, so the only data on this form is erroneous to start with.
There are, however, images of different specimens where the accession number was repeated in the past.
These duplicates have been removed to a separate table for correction.
All existing accession numbers in the main data table are computer generated and duplicates are not permitted.
So, yes, if you entered an artificial double both rows would highlight as they are linked to a hidden textbox that is precisely for that purpose, hence the "0's" all lighting up.
I thank you for your input.
John