Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Highlight current row in form (Access 2000) 1

Status
Not open for further replies.

BSman

Programmer
Apr 16, 2002
718
US
Is there a way to highlight the current data row in an Access 2000 continuous form? I would think of changing the background color of the specific row (detail section), but I can't find a property that would let me do that. An OnGotFocus property even of a control won't work for a number of reasons, an important one being that one use of this would be on a form containing two subforms, the second one of which shows (and allows the user to add/edit) detailed data related to the current row on the first subform.
 
There are two ways to do it..
First is to set the textbox control backcolor to the highlight color. Then set the traparent property =Yes
This way highlight color will be used once the curser move into the control
Second is
Color 95 from mvps.org
Regards


Zameer Abdulla
Visit Me
 
Unfortunately, the Color 97/95 doesn't do the job. And conditional formatting in Access 2000 can be used for some of the same results.

The first suggestion you made does work, although it's just highlighting one control in the row. But at least it give the user some indication of the current row, as long as the user clicks on that one control.

Thanks.
 
Glad it worked
There was a better solution in my collection. I don't remember now. If I can find I will post here..


Zameer Abdulla
Visit Me
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top