Record Number & Conditional formatting

[Lorena]

I have a form that I want to change colors for every other row. I am using
conditional formatting and figuring that I need to obtain the record number
to determine what color to use (ie. blue for evens, yellow for odds).
However, I cannot find the correct name for Record number.

I tried '[RecordNumber] Mod 2 = 0' in the conditional formatting area and
it doesn't seem to work. I placed '=[RecordNumber]' in an unbound text and
it gave me '#Name?' error. It likes '=[CurrentRecord]' , however, record 0
gives me a value of 0, and the rest of the rows give me a value of 1. Of
course, '=[RecordCount]' gives me the total record count, which is not what I
want.

Any suggestions

 

[Rick B]

Please note, this is asked and answered all the time. In the future, I'd
suggest you search for your answers before posting a new thread. The
easiest way I have found is to go to www.google.com, click the "groups"
option, and enter a search string similar to the following...

microsoft.public.access alternate shading



I did this and found about 50 posts that address your issue.

 

[Lorena]

At the very least, can someone answer me this? I have tried researching it
and not seem to find an answer. I want to at least retrieve or display the
record number of each record (on each row in the detail section of a form).
When a record is deleted, say 4th record, then records 1, 2, 3, 5 should
display 1, 2, 3,4 as you would see in the record navigation section at the
bottom of the form. Is there no way to retrieve the record number.
CurrentRecord does not work for me because it will obviously return only the
number of the record I am currently on. Fixed number values (say from the
table) do not help me. Retrieving the record number seems to be my answer
but I don't know how to get it.


--
Lorena

Please note, this is asked and answered all the time. In the future, I'd
suggest you search for your answers before posting a new thread. The
easiest way I have found is to go to www.google.com, click the "groups"
option, and enter a search string similar to the following...

microsoft.public.access alternate shading



I did this and found about 50 posts that address your issue.


--
Rick B

I have a form that I want to change colors for every other row. I am using
conditional formatting and figuring that I need to obtain the record
number
to determine what color to use (ie. blue for evens, yellow for odds).
However, I cannot find the correct name for Record number.

I tried '[RecordNumber] Mod 2 = 0' in the conditional formatting area and
it doesn't seem to work. I placed '=[RecordNumber]' in an unbound text
and
it gave me '#Name?' error. It likes '=[CurrentRecord]' , however, record
0
gives me a value of 0, and the rest of the rows give me a value of 1. Of
course, '=[RecordCount]' gives me the total record count, which is not
what I
want.

Any suggestions