Hello,
Could you please help how to Highlight an entire row in a sub form in ms access
see printschreen and attachement.
Hello,
Could you please help how to Highlight an entire row in a sub form in ms access
see printschreen and attachement.
Something like this?
Screenshot from my article https://www.isladogs.co.uk/emulated-...orm/index.html
A quick Google search will give lots of articles explaining how this is done. For example: How To Highlight The Current Row In A Continuous Form In 3 Steps (vbahowto.com)
Yes, how to make it
I've given you two links - one to a working example and the other to detailed instructions. Now its up to you to implement this for yourself.
Here's another example with a continuous form, an emulated split form & a datasheet (where the effect is built in)
Study the continuous form example which is slightly different from that on the vbahowto.com link
Firstly, that dummy field has to be on the detail line. Then you need to apply conditional formatiing to every control on that record?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
My approach is slightly simpler. Only one control needs to have conditional formatting applied
I've just written detailed instructions in a new web page: Highlight Current Record in Continuous Form (isladogs.co.uk)
I tried to make it like in the example but it didn't work, please see in my databse, what I did wrong. I'm a little crazy about this matter
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
My new web article provides detailed instructions along with an example database showing that in action.
The last screenshot you showed preceded me doing that.
I spent almost 2 hours creating that article. Study it carefully & apply it to your own database.
I'm not going to do the rest of this for you or you will learn nothing.
In your post #1, I see a continuous form, but on your picture it is somehow weird - the are no record selectors at left of every row (look at Isadog's post #2 - in 11th row which is selected one, it is black, with tiny arrow in it)
In your later postings, all those pictures are displaying various single forms. In single form, the displayed row is always the selected one.
So I'm somewhat confused - what are you meaning with "highlight", and for what you need this. I'm suspecting you want to copy the entire row from form, and paste it somewhere!
@Arvil
It is a continuous form but the OP didn't correctly follow the method described in my link in post #2.
The yellow box on the top right is a 'marker' used to indicate the current record ID. Its normally hidden
I've since provided a working example and detailed instructions for a simpler method but he(?) hasn't shown any indication of having tried it
BTW Record selectors aren't required in a continuous form nor are they needed to highlight the current record (though it may make it easier to do so)