Form Programming

[Peter Weinwurm Jr]

Dear Access experts

I have a continous form with over 30 columns. As a result it is hard to
know which column I am at. What I would like to do is HIGHLIGHT (or change
color of)
the label for the colum that has the focus at the moment.


Hence, if I am at record 5, column 15 I would like the label for Column 15
to show up red for example while the other labels are black. Then if I
select another field in column 25 I want the column 25 label to be red while
the others are black.


What is the most effecient way to write this code. (I know I can do it
using on got focus and lose focus of the field (column) and put this code in
ever field but that seems ridiculous to me.)


Thanks so much

Peter.

 

[RobFMS]

Peter

Are you aware that you can put labels in the Form Header section, which
directly correspond to the fields in the detail section? When you view the
form, the labels will contain the column names, regardless of where you
scroll.

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-