RE: Highlighting a row by using the records selector

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Alex (anonymous_at_discussions.microsoft.com)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 09:25:32 -0700

Thanks a lot, Tom.
I was experimenting yesterday and found that Me.Repaint
without anything else is working better (I tried your
stuff as well today). Me.Repaint doesn't eliminate
blincking but makes it little bit better than Me.Refresh.

Regards,

Alex
 
>-----Original Message-----
>Alex,
>
>I think the blinking is a function of the size of the
continuous form's
>record set, the speed of your PC and whether or not the
continuous form
>includes computed values.
>
>Also note the the original version of Access 2003 had a
bug when computed
>values and conditional formatting were combined that
produced, among other
>things, a blinking effect. The Access 2003 update that
came out a few weeks
>ago fixed this.
>
>I'm not certain but putting a
> Me.Painting = FALSE
>just before the Refresh and a
> Me.Painting = TRUE
>just after it might eliminate the blink.
>
>Tom
>
>"Alex" wrote:
>
>> Thanks a lot, Tom. It's working very good (just the
form
>> is little bit blinking when refreshing).
>> >-----Original Message-----
>> >My error. It isn't GotFocus, it is the Current event.
>> >
>> >Tom
>> >
>> >"Alex" wrote:
>> >
>> >> Thanks again, Tom. Sorry, but I'm putting it as a
new
>> post
>> >> to don't miss it in the old posting.
>> >> It looks like a very good approach.
>> >> But, when I'm clicking on the Records Selector the
>> Form's
>> >> GotFocus event isn't working.
>> >> >-----Original Message-----
>> >> >Alex,
>> >> >
>> >> >By "record identifier" I mean some field in the
record
>> >> that makes it unique.
>> >> > Could be a customer name, ID number, date,
whatever.
>> >> >
>> >> >Yes, the unbound control would be a text box with
its
>> >> Visible property set
>> >> >to No.
>> >> >
>> >> >Let's say the unbound control is named txtTgtCust
and
>> the
>> >> control that
>> >> >contains the record identifier is named
txtCustName.
>> In
>> >> your conditional
>> >> >formatting, you would set an expression that would
>> cause
>> >> a backgound fill to
>> >> >be like hilghighting like so...
>> >> > [txtTgtCust] = [txtCustName]
>> >> >
>> >> >"Alex" wrote:
>> >> >
>> >> >> Thanks a lot Tom.
>> >> >> But, could you please clarify how the unbound
>> control
>> >> (is
>> >> >> it texbox?) can contain the selected records
>> identifier
>> >> >> (what is that?).
>> >> >> I know how to set the conditional formatting.
>> However,
>> >> I
>> >> >> have no idea how I should check whether the
unbound
>> >> >> control and selected records identifier are equel
>> and
>> >> copy
>> >> >> the record identifier to the unbound control.
>> >> >>
>> >> >> Regards,
>> >> >>
>> >> >> Alex
>> >> Alex,
>> >> Unfortunately Access doesn't have a built-in way to
>> >> highlight records in a
>> >> continuous form. But you can simulate it by using
>> >> Conditional Formatting...
>> >>
>> >> - Add an unbound control to the forms header that
will
>> >> contain the selected
>> >> records identifier.
>> >> -Add a "background" text control that is behind
>> everything
>> >> else. Include
>> >> conditional formatting that makes it filled with
your
>> >> highlite color when the
>> >> reced identifier and the unbound control are equal.
>> >> - Add code to the form's GotFocus event that copies
the
>> >> record identifier to
>> >> the unbound control and then refreshes the form
>> >> (Me.Refresh)
>> >>
>> >> There are variations on this theme but I hope this
>> might
>> >> give you the basic
>> >> idea.
>> >>
>> >> Tom
>> >>
>> >>
>> >> "Alex" wrote:
>> >>
>> >> > I have a continious form with textboxes and with a
>> >> Record
>> >> > Selector. When I'm clicking on the Record Selector
>> there
>> >> > is an arrow on it pointing on the row.
>> >> > How could I, in addition, make the whole row
>> (textboxes)
>> >> > highlighted by clicking on the Record Selector.
>> >> >
>> >> > Thanks in advance
>> >> >
>> >> ..
>> >>
>> >>
>> >>
>> >>
>> >.
>> >
>>
>.
>

Relevant Pages

  • RE: Highlighting a row by using the records selector
    ... I think the blinking is a function of the size of the continuous form's ... record set, the speed of your PC and whether or not the continuous form ... things, a blinking effect. ... just before the Refresh and a ...
    (microsoft.public.access.formscoding)
  • Re: Postback with no delay??
    ... that there is no blinking (e.g. white page background versus a dark page ... This refresh is happening VERY fast to the ... backs however, since the entire page does not need to be redrawn, it ... to do the postbacks and the blinking between postbacks is almost ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Plasma vs LCD Refresh Rates
    ... plasma displays "blink" and need a higher Refresh rate in the ... panel to increase the frequency of the blinking. ... My understanding is that while each cell of the plasma display ...
    (alt.tv.tech.hdtv)
  • Re: Postback with no delay??
    ... This refresh is happening VERY fast to the ... backs however, since the entire page does not need to be redrawn, it ... to do the postbacks and the blinking between postbacks is almost ... very small I still can clearly see the blinking between pages postbacks ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Postback with no delay??
    ... This refresh is happening VERY fast to the ... to do the postbacks and the blinking between postbacks is almost ... very small I still can clearly see the blinking between pages postbacks ... Is there any way I can do like wachovia? ...
    (microsoft.public.dotnet.framework.aspnet)