Highlight selected row.

[lina2401]

Hi all! I really need help with this!!
I have a form which displays list or applications in continuous form and when the user clicks on the application ID the attached subform is displayed with the corresponding data! What I need is to highlight or bold the application ID if it is clicked just to know which one has been clicked on! Is there a way on which I can accomplish this??

Thanks in advance.

 

[ajetrumpet]

What I need is to highlight or bold the application ID if it is clicked just to know which one has been clicked on! Is there a way on which I can accomplish this??

Use the click event of the ID text box and the backcolor property!!!!

 

[lina2401]

Thanks for replying!
Can you please submit a sample code.
Thanks again.

 

[ajetrumpet]

This is the code:

Me.textbox.BackColor = "whatever color pallet number you want here" (example - 174630)

If you just write this though, on a continuous form, you're going to see all of the same field's textboxes on all of the visible records turn color as well. So, you need a unique identifier of somekind. Use a value that satisfies this from either your main form or subform. You should have one, especially if your subform is linked to the main. Use the PK from the main.

 

[DLewis2002]

How do you reference the Key field in VBA? Or can you put a sample of it like the one you did above.

Thanks

 

[missinglinq]

To do this in a Continuous View Form you cannot use code, you have to use Conditional Formatting.

In Design View

1. Select the Control
2. Go to Format - Conditional Formatting
3. In the Condition Dropdown select Field Has Focus
4. Use the icons to the right to set the formatting of the control as you wish

Linq ;0)>