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

[Kirana123]

Hello,

Could you please help how to Highlight an entire row in a sub form in ms access



see printschreen and attachement.

[isladogs]

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)

[Kirana123]

Yes, how to make it

[isladogs]

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.

[Kirana123]

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.

I tried to make it like the one in the link but the results are not the same as the one in the link I attach photos and databse

[isladogs]

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

[Welshgasman]

Firstly, that dummy field has to be on the detail line. Then you need to apply conditional formatiing to every control on that record?

[isladogs]

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)

[Kirana123]

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

[Welshgasman]

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

Attach your DB again, do NOT make us going to look for it? :-(

[isladogs]

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.

[ArviLaanemets]

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!

[isladogs]

@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)