Highlighting a row by using the records selector

[Alex]

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]

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

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

..

 

[Alex]

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

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]

:

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

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

..

.

 

[Guest]

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

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

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]

:

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


:

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

..

.

 

[Alex]

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

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

:

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]

:

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


:

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

..




.

.