highlighting the current record

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

re: highlighting the current record

On Mon, 6 Jun 2005 13:35:10 +1200, windandwaves wrote:
[color=blue]
> 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[/color]

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.

re: highlighting the current record

fredg wrote:[color=blue]
> On Mon, 6 Jun 2005 13:35:10 +1200, windandwaves wrote:
>[color=green]
>> 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[/color]
>
> 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.[/color]

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
[color=blue]
>
> And also look at:
> http://www.lebans.com/alternatecolordetailsection.htm[/color]

re: highlighting the current record

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" <winandwaves@coldmail.com> wrote in message
news:42a3cfad$1@clear.net.nz...[color=blue]
> fredg wrote:[color=green]
> > On Mon, 6 Jun 2005 13:35:10 +1200, windandwaves wrote:
> >[color=darkred]
> >> 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[/color]
> >
> > 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.[/color]
>
> 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[/color]
well.[color=blue]
>
> 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 "[/color]
&[color=blue]
> screen.activeform.currentrecord & ",1" or something like that.
>
> Thanks for your useful response
>
> - Nicolaas
>[color=green]
> >
> > And also look at:
> > http://www.lebans.com/alternatecolordetailsection.htm[/color]
>
>[/color]

re: highlighting the current record

Larry Linson wrote:[color=blue]
> 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
>
>
>[/color]


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