highlighting the current record

[windandwaves]

Hi Folk

Is there anyone out there who knows if there is an easy way to highlight the
currentrecord using conditional formatting or something like that in Access
2003?

Thank

Nicolaas

[fredg]

On Mon, 6 Jun 2005 13:35:10 +1200, windandwaves wrote:

Hi Folk

Is there anyone out there who knows if there is an easy way to highlight the
currentrecord using conditional formatting or something like that in Access
2003?

Thank

Nicolaas

See
http://www.lebans.com
specifically:
http://www.lebans.com/conditionalformatting.htm

You can down load a sample database that includes various uses for
shaded lines, including continuous form alternating lines and
highlighting the selected line.

And also look at:
http://www.lebans.com/alternatecolordetailsection.htm
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[windandwaves]

fredg wrote:

On Mon, 6 Jun 2005 13:35:10 +1200, windandwaves wrote:

Hi Folk

Is there anyone out there who knows if there is an easy way to
highlight the currentrecord using conditional formatting or
something like that in Access 2003?

Thank

Nicolaas
See
http://www.lebans.com
specifically:
http://www.lebans.com/conditionalformatting.htm

You can down load a sample database that includes various uses for
shaded lines, including continuous form alternating lines and
highlighting the selected line.

Hi Fred, I downloaded the thing, and that is cool, but it seems really
complicated for something really simple. It should just be one expression
in conditional formatting (that I am looking for), not endless lines of
code. I actually tried to make a conditional format with the following
expression:

screen.activeform.currentrecord = [id]

where [id] is the field on the form, but that did not seem to work too well.

I am thinking, I may be able to concoct a little function with
screen.activeform.currentrecord and compare it to the ID field (which is
always present on my form), obviously, IDs are not always neatly numbered
1,2,3,4,5 but you may be able to do the "SELECT ID FROM RECORDSET LIMIT " &
screen.activeform.currentrecord & ",1" or something like that.

Thanks for your useful response

- Nicolaas

And also look at:
http://www.lebans.com/alternatecolordetailsection.htm

[Larry Linson]

There's no "change color for the whole record" option. In a continuous forms
view form, I can look at the record selector to see which one is selected,
if Stephen's method seems to complex.

I think Microsoft has a wish list for requests for future improvements, but
I don't have the URL handy.

Larry Linson
Microsoft Access MVP


"windandwaves" <wi*********@coldmail.com> wrote in message
news:42********@clear.net.nz...

fredg wrote:

On Mon, 6 Jun 2005 13:35:10 +1200, windandwaves wrote:

Hi Folk

Is there anyone out there who knows if there is an easy way to
highlight the currentrecord using conditional formatting or
something like that in Access 2003?

Thank

Nicolaas
See
http://www.lebans.com
specifically:
http://www.lebans.com/conditionalformatting.htm

You can down load a sample database that includes various uses for
shaded lines, including continuous form alternating lines and
highlighting the selected line.

Hi Fred, I downloaded the thing, and that is cool, but it seems really
complicated for something really simple. It should just be one expression
in conditional formatting (that I am looking for), not endless lines of
code. I actually tried to make a conditional format with the following
expression:

screen.activeform.currentrecord = [id]

where [id] is the field on the form, but that did not seem to work too

well.
I am thinking, I may be able to concoct a little function with
screen.activeform.currentrecord and compare it to the ID field (which is
always present on my form), obviously, IDs are not always neatly numbered
1,2,3,4,5 but you may be able to do the "SELECT ID FROM RECORDSET LIMIT " & screen.activeform.currentrecord & ",1" or something like that.

Thanks for your useful response

- Nicolaas

And also look at:
http://www.lebans.com/alternatecolordetailsection.htm

[windandwaves]

Larry Linson wrote:

There's no "change color for the whole record" option. In a
continuous forms view form, I can look at the record selector to see
which one is selected, if Stephen's method seems to complex.

I think Microsoft has a wish list for requests for future
improvements, but I don't have the URL handy.

Larry Linson
Microsoft Access MVP

Hi Larry

Yes, that is a shame. I would not actually even care of the whole record
changed color ... maybe it was just a matter changing one of the controls
(e.g. red border or so). I never use the record selectors, because they
just look so eighties. Basically my question boils down to : "can you
change the recordselectors into something with a funkier colour and a
smarter look?"

Thank you for your note.

- Nicolaas