How to Highlight an entire row in a sub form in ms access

[dodo]

thank you for your quick and thorough reply.

I am approaching the end of my work day so im gonna get back on this tomorrow afternoon.
Probably I did something wrong in my setup. Also I'm happy you pointed out I can do formatting in a list. This will solve at least the 'deadline' issue

Tomorrow I will look at the issue and go throught the articles you send me and reflect which method will work out for me best.

This is my first project in Access, so I'm still exploring what are the best practices for my project and in to what extent I will stumble on limitations or issues from my current choices of method and design.

kind regards
d

[dodo]

thank you for your quick and thorough reply.

I am approaching the end of my work day so im gonna get back on this tomorrow afternoon.
Probably I did something wrong in my setup. Also I'm happy you pointed out I can do formatting in a list. This will solve at least the 'deadline' issue

Tomorrow I will go through the issue and the articles you send me and reflect which method will work out for me best.

This is my first project in Access, so I'm still exploring what are the best practices for my project and in to what extent I will stumble on limitations or issues from my current choices of method and design.

kind regards
d

[isladogs]

You’re welcome but a couple of points:
1. Formatting in list boxes is VERY limited. It’s very unlikely that it will be much use to you
2. Some of my examples are quite complex. There may be techniques that are too advanced for someone on their first project.

Good luck

[dodo]

So I looked at my problem.
And I found that i need one control that is enabled for it too work. Otherwise probably you have no means to select the row. Then I found, as you told, the allowedits property on the form.
This solves the issue.

I also looked at the links you send me, and there is some pretty useful information i'm gonna implement in a later phase.
Thanks again!

[dodo]

I know the complexity of writing a functional software (in access) is hard. I try to divide the scope of the project in phases, worked out my database in 2ndNF. But while ongoing I have been changing some stuff. I'm trying to evade double work, as I am doing now with the list -> continuous form. But there is just too much to learn at once to waste no time in that process

I am grateful there is a community out there willing to help!

[isladogs]

So I looked at my problem.
And I found that i need one control that is enabled for it too work. Otherwise probably you have no means to select the row. Then I found, as you told, the allowedits property on the form.
This solves the issue.

I also looked at the links you send me, and there is some pretty useful information i'm gonna implement in a later phase.
Thanks again!

The only control that must be enabled is the blank textbox behind all the other controls - that is the control which has conditional formatting applied to give the highlighted effect.
All the other controls can be disabled or locked...or you can set the form to AllowEdits=False as already stated.

Don't try to learn everything at once or you will become overwhelmed!
I've been using Access regularly for almost 30 years . . . and I'm still learning new things

[almontaser92]

A long time ago I found a function that performs this operation and I modified it until I reached this result that I attached to the isladogs example, where an issue that was bothering me due to the width of the text box that highlights the row because it interferes with the rest of the controls because it takes the same width as the form and the other issue is changing the background color of the text box that is focused on, as well as dealing with the new record also added the ability to select the highlighting color through the code.
Everything that is required is explained in the code but in short these are the steps

1. Import the mdlHighlightRow module
2. Create a text box in the details section (it does not matter how wide) and modify its properties as follows

• Control Source = [the name of the field that contains the unique values]
• Enabled = No
• Locked = Yes
• Background Style = Normal
• Special Effect = Flat
• Font Size = 1
• Tag = "UniqueValue"
• Send it to the back of other controls

1. Assuming that the textbox set up in the settings above was named [txtUniqueValue] Add the following to the form's OnCurrent event

• =HighlightRow([txtUniqueValue]) "OnCurrent event in the Properties sheet"

Or

• Call HighlightRow([txtUniqueValue]) " within the OnCurrent subprocedure "

That's all, please see the attached file and provide any feedback

HighlightCurrentRecord.zip

[davegri]

And the problem is???
Please provide instructions on how to demonstrate the problem(s) you are having.

Note: this is a 4 month old thread. It probably would have been better to start your own new thread with a reference to this one in your text.

[almontaser92]

And the problem is???
Please provide instructions on how to demonstrate the problem(s) you are having.

Note: this is a 4 month old thread. It probably would have been better to start your own new thread with a reference to this one in your text.

OK, I've started a new thread.