Highlight Selected Row in Tabular Form

[Cosmos75]

Is there anyway to highlight the currect selected row in a form that is tabular? Other than using a record selector, it's hard to tell which row a user is on in the form.

 

[Cosmos75]

Conditional Formatting - Highlight Selected Field

The closest I can figure is to use Conditional Formating and choose condition Field Has Focus to format the selected field.

This works in Access 2000. But I were to convert the Access 2000 database to an Access 97 database, would the conditional formatting still work for someone using Access 97?

 

[rockman]

Cosmos,

Do the fields still have to be edittable or is this just a list that the user selects a particular record?

Jeff

 

[Cosmos75]

Does it make a difference?

 

[pcs]

cosmos,

-----you wrote-----
This works in Access 2000. But I were to convert the Access 2000 database to an Access 97 database, would the conditional formatting still work for someone using Access 97?
-------------------

sorry no...

hth,
al

 

[rockman]

I was going to suggest you considering using the MS Flex Grid control if all you needed was a list to select from. If the items listed need to be edittable I would not go this route.

Jeff

 

[Cosmos75]

Problems using Access 2000 conditional formating in Access 97???

If I use the conditional formating to highlight the field that has the focus (Access 2000), and I save it as an Access97 file. Will that cause problems for a user who is using the database in Access 97??

 

[Cosmos75]

An answer!

http://www.lebans.com/conditionalformatting.htm

Download this!! It's prety cool!!

Highlights the ENTIRE row of the selected row!

 

[Cosmos75]

I haven't been able to get this to work for a sub-form....

Have emailed the person who created it in hopes of finding help. Does's anyone here now how to do it?

'This is what is giving me problems.
'fsubConstituentWt is a subform on !frmConstituentWt
CF.BGTextBox = Forms![frmConstituentWt].[fsubConstituentWt].txtBackGround

Am I referencing the subform correctly?

What are the rules for referering to Subforms or SubSubForms??

 

[Jerry Stoner]

Either of these should work

CF.BGTextBox = [Forms]![frmConstituentWt].[fsubConstituentWt].[Form].txtBackGround



CF.BGTextBox = Me.fsubConstituentWt.Form.txtBackGround

Heres a way to get the syntax right every time:
Put a textbox on your main form and use the expression builder to go to you control on sub or subsubform from that textbox. Copy and paste into your code. Then of course delete your textbox. Pretty sure Rich taught me that!