Highlighting a row that has been selected.

[kcdoell]

Hello:

In my continuous form, if I select a row a small arrow button displays in the far left. What is the best way to have the background color change for just that row. I have figured out how to do this for any particular field that is selected but not the entire row.

Any ideas would be helpful.

Thanks,

Keith.

[kcdoell]

Hello:

In my continuous form, if I select a row a small arrow button displays in the far left. What is the best way to have the background color change for just that row. I have figured out how to do this for any particular field that is selected but not the entire row.

Any ideas would be helpful.

Thanks,

Keith.

Hello again:

To further clarify, since I know how to do this using the "get focus" / "Lost focus" of a particular field's properties on the form, I was wondering whether I could set this property (forecolor) for the whole record, rather than just one field?

Any ideas would be helpful,

Thanks,

Keith.

[FishVal]

Hi, Keith.

I recall something similar in http://bytes.com/forum/thread748875.html

Regards,
Fish

[kcdoell]

Fish:

I read the other thread and I am still confused because I am not using a check box to highlight but rather the default arrow indicator that displays when a user selects a row. I have an image of this in another thread.
[HTML]http://bytes.com/forum/thread792157.html[/HTML]

I am not too sure where I go from here.

Can you shed more light?

Thanks,

Keith.

[FishVal]

Hi, Keith.

AS you've already figured it out setting property of control on form in continuous or datasheet view will affect all rows as it basically just the same control. The only way (at least I know only this one :)) to change control appearance for a particular row is to use conditional formatting.

The logic I've used is the following:

• conditional formatting may accept a value of a field in a record as criteria
• that means field value has to indicate whether the record is active
• obviously it requires an additional field in the bound table, boolean field will serve quite well - let us call it blnIsActive
• conditional format of all form controls is set to change background colour when [blnIsActive]=True
  

  Expression is
  [Forms]![Form name]![blnIsActive]=True
   

• now we need to change [blnIsActive] value to True when record gets focus and reset to False when it looses focus.
  
  

  Private Sub Form_BeforeUpdate(Cancel As Integer)
      Me.blnIsActive = False
  End Sub
   
  Private Sub Form_Current()
      If Not Me.NewRecord Then Me.blnIsActive = True
  End Sub
   

  Note: no control, either visible or not, bound to [blnIsActive] is needed on the form.

Regards,
Fish

[kcdoell]

Fish:

I am trying to apply this method:

I went to one of my controls on my form (Policy_Type), right click, went to conditional formating, selected "expresion is" and inputted the following:

[Forms]![Forecast]![blnIsActive]=True
 

Then I inputed the code to my form:

Private Sub Form_BeforeUpdate(Cancel As Integer)
    Me.blnIsActive = False
End Sub
 
Private Sub Form_Current()
    If Not Me.NewRecord Then Me.blnIsActive = True
End Sub
 

But nothing happens. You said that "blnIsActive" was not needed on my form. Do I need to add it to my table?? I believe I would. I am thinking that that is where I am making the mistake in your solution.

Any ideas?

Thanks,

Keith.

[kcdoell]

Fish:

I now you must be busy but when you have the time if you could give me a little more detail on how I incorporate "blnIsActive" that would be great. I never applied a boolean expresion let alone now exactly what it is. I am going to do some research on Booleans.

Let me know your thoughts

and thanks!

Keith.

[kcdoell]

Fish:

I think a lightbulb went off in my head about boolean (Yes/No field in Access). I am going to try that........

Keith.

[FishVal]

.....
You said that "blnIsActive" was not needed on my form. Do I need to add it to my table?? I believe I would. I am thinking that that is where I am making the mistake in your solution.
.....

It is what the whole logic is based on. Have you added [blnIsActive] field to the table?

Kind regards,
Fish

[kcdoell]

Fish:

Okay, I think I am getting there. What I did was create a new field on my table called "RowIsActive" and set its data type to Yes/No. Then I put the following code:

Private Sub Form_BeforeUpdate(Cancel As Integer)
 
Me.RowIsActive = False

Private Sub Form_Current()
    If Not Me.NewRecord Then Me.RowIsActive = True
End Sub

I hit the error on the later. I thought I was going to have an issue because when I was typing in the "me." expression "RowIsActive" was not a selection for me to choose from. Hence, when I opened the form I hit an error

"Method or data member not found (Error 461)" 

My row source for this form is pointing to a query I created. I made sure that the "RowIsActive" field was included in the query but still the same error. I believe you indicated that I did not have to place the field on the form itself in order for this to work.

Am I correct on that understanding?

Thanks,

Keith.

[FishVal]

Actually as long as [RowIsActive] field is among the fields returned by form recordsource it should be available as property of the form object or a member of form controls collection:
Me.FieldName
or
Me!FieldName

As an option you may put a control (e.g. checkbox) bound to [RowIsActive] field.
Give it the same name - [RowIsActive] to make no changes to code. This way the code will not throw the error as the references will be to the existing control and you will see how its value changes when selecting different records.

Regards,
Fish

[kcdoell]

Actually as long as [RowIsActive] field is among the fields returned by form recordsource it should be available as property of the form object or a member of form controls collection:
Me.FieldName
or
Me!FieldName
As .......................................
Regards,
Fish

Fish:

All I had to do was change the code to Me!FieldName and it worked. To better understand this, what made the difference?? That is to say I know that I changed the "." to a "!" but how can Access find the control in one way and not the other?

I hate the fact that I am wasting your precious time on little formatting issues.

Thanks,

Keith.

[FishVal]

The issue was discussed in several threads before.
Access2003 Form/Query
"Property let procedure..." error occurs when opening form determined by listbox data
Control Object Reference (Me!)

Regards,
Fish