Conditional Formatting form fields on 1st entry and every 10th entry.

[arneym]

I have a form that acts as a log sheet. The operator does a 1st piece check (all fields are to be filled out), and then I want certain checks to be conditionally formatted black until the 10th piece (all field are to be filled out again). Here is an example:



1st Piece:
data
data
data
data
data

2nd Piece(New Record):
data
data
Blacked out
Blacked out
Blacked out
.
.
.
.
.
.
.
10th Piece:
data
data
data
data
data

[June7]

Refer to http://www.lebans.com/rownumber.htm for examples of generating row number in queries and forms. Download the sample db.

Use Conditional Formatting http://msdn.microsoft.com/en-us/libr.../gg508986.aspx.
Use Expression with condition dependent on the row number: [Text23]=1 Or [Text23] Mod 10=0

[arneym]

Refer to http://www.lebans.com/rownumber.htm for examples of generating row number in queries and forms. Download the sample db.

Use Conditional Formatting http://msdn.microsoft.com/en-us/libr.../gg508986.aspx.
Use Expression with condition dependent on the row number: [Text23]=1 Or [Text23] Mod 10=0

Thank you for your suggestion, but I could not get it to work. The example was for a single, continuous row. Here is my Database:
Help.accdb

I put text on the side of each field to describe what I am looking for.

[June7]

I tested this suggestion with my db and it worked great.

Why didn't it work work for you - error message, wrong results, nothing happen?

The db you posted has no data and no code to evaluate.

[arneym]

Thank you for your quick response!
I had to delete everything that I did, because it said that it was too big. I did compact and repair. I thought that we had 2MB to play with and mine was only 800K. It would only give me 500K, which I squeaked by at 490K. I thought that a visual of my form would help explain things better.

I understand how it adds 1 to each row, but your example had 1 continuous row. My form has 21 rows. I'm not getting it to work.

[June7]

Your form is set to SingleForm view, that means a single record displays. A record is one 'row'. The 'rows' you reference are fields of that one record arranged vertically instead of horizontally (I count 20, a textbox with the row number generated by the function would make 21). Apply Conditional Formatting to each textbox you want to show up every 10 records.

Attempt and if still need help, post file with code. 2mb zip allowed.

[arneym]

Sorry for not responding sooner. I had been pulled away from this project for a little while. Thanks for your help, I got it now.