Re: Record Number & Conditional formatting
- From: "Rick B" <Anonymous>
- Date: Wed, 1 Mar 2006 08:53:01 -0600
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
"Lorena" <Lorena@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:48C52A68-979A-4198-A379-58EB42CC2EE9@xxxxxxxxxxxxxxxx
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
--
Lorena
.
- Prev by Date: Re: Unbound combo displays blank after applying a me.filter
- Next by Date: Re: Want to open a form and it be ready for a new record
- Previous by thread: Cannot get Calendar Control to work properly
- Next by thread: Re: Want to open a form and it be ready for a new record
- Index(es):
Relevant Pages
|
