High Light current record in a continuous form

[NauticalGent]

Good morning AWF,

I found this thread from 2004 and although the attachment's instructions work as advertised, I find it hard to believe that this hack is the only way to achieve this result.

So, the question is, now that 16 years has transpired, IS there a better way to do this?

Thanks in advance!

 

[NauticalGent]

Actually, further in the thread, post 15 has a much simplier solution. Guess I should have kept reading...

Still open to other's ideas if there is a better way.

 

[strive4peace]

hi John,

here is a video I made to do this:

Highlight Current Record in Access

Steps are listed here:
http://msaccessgurus.com/VBA/Database/Highlight.htm

I tried to copy them to this post, but the formatting got all messed up!

 

[strive4peace]

ps, there was a reason I didn't use a calculated control to track the current record, and set it with VBA instead ... but now I can't remember why!

 

[arnelgp]

simply use CF on Current record.

 

[deletedT]

simply use CF on Current record.

Do you mean the same way as @strive4peace showed in the video?

 

[MajP]

I didn't use a calculated control to track the current record, and set it with VBA instead ... but now I can't remember why!

In older versions of Access this could cause serious flicker, that is probably why.

 

[isladogs]

Have a look at how this effect is achieved in the Emulated split form.

 

[NauticalGent]

Crystal, thanks for the video and link. Very informative and easy to follow. CID's method is very similar so I will digest both of them tonight over a stout and come up with a plan.

Thanks both of you, I am going to post a link to this thread on the one I looked at first so that future wanderers do not waste their time like I did...

Colin, I noticed on your site that you will be posting a Class Module version of your ESF - looking forward to it.

Thanks again!

 

[isladogs]

Hi NG
Sorry but it was going to be provided by a colleague from Italy but it wasn't completed. I need to edit my Web page accordingly

 

[NauticalGent]

Hi NG
Sorry but it was going to be provided by a colleague from Italy but it wasn't completed. I need to edit my Web page accordingly

Well hell...

 

[strive4peace]

Crystal, thanks for the video and link. Very informative and easy to follow. CID's method is very similar so I will digest both of them tonight over a stout and come up with a plan.

my pleasure, John -- have one for me too!

and now I know why you can't just set control source of the field to track the current ID -- it doesn't work! ... even if you do it as an external reference -- well maybe if you put it that way in the CF condition too (I didn't try), but that prevents you from using the same form somewhere else.

 

[isladogs]

Well hell...

Unfortunately, he got seriously ill (prior to COVID) and gave up development work after recovery.

 

[zeroaccess]

Here's mine, using a tweaked version of CJ's method.

1. Subform footer has an unbound invisible text box named txtPK
2. On Current event of subform contains the following: Me.txtPK = Nz(Me.[yourprimarykeyID], 0)
3. Conditional formatting is applied per attachment

Field will highlight as you move through because the ID of the record equals the value in the hidden text box. If new record, there will be no highlight but also no erroneous behavior. Tried using an expression for new record and get much erroneous behavior. Conditional formatting is weird.