highlight cell that cursor is in

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JMspecial - 28 Feb 2006 16:55 GMT

I am trying to figure out how to highlight a row all the way across (several
columns) a table to show where the curor is. So if the cursor is on row 22
and in the 4th column, I want the entire row to be highlighted. If this is
not possible then how can I highlight just the text field that the curor is
in?

Thanks

Reply to this Message

tina - 28 Feb 2006 17:10 GMT

if you're using Excel (rows and columns), suggest you post your question to
an Excel newsgroup. if you're using Access (records and fields), then you
can't do it in Datasheet view of a *table*. instead, use a form to view your
data and, in A2000 or newer version, set Conditional Formatting (under
Format on the menu bar in form design view) on each bound control in the
form to change the BackColor property using the FieldHasFocus option.

hth

> I am trying to figure out how to highlight a row all the way across (several
> columns) a table to show where the curor is. So if the cursor is on row 22
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

chris.nebinger@gmail.com - 28 Feb 2006 18:45 GMT

Well, you can do it via code, but there the method is very clunky.

The code would look like:

Dim ctl As Control
Set ctl = Screen.ActiveControl
ctl.Parent.Controls(0).SetFocus
ctl.Parent.SelWidth = ctl.Parent.Count

Now, the question remains on how do you start this code. The only way
I can think of is to use a hidden form with a timer to check every so
often. Alternatively, datasheet views would work as well.

On a datasheet view, simply add this to the OnCurrent event, and you
will have exactly what you are looking for.

Reply to this Message