{"id":1029,"date":"2015-12-10T23:13:58","date_gmt":"2015-12-11T04:13:58","guid":{"rendered":"http:\/\/regina-whipp.com\/blog\/?p=1029"},"modified":"2016-01-01T19:28:07","modified_gmt":"2016-01-02T00:28:07","slug":"highlight-current-record","status":"publish","type":"post","link":"https:\/\/regina-whipp.com\/blog\/?p=1029","title":{"rendered":"Highlight Current Record…"},"content":{"rendered":"

Highlighting the current record is an often asked question.\u00a0 You could use Conditional Formatting but then you have to do it for each Control in the Detail section of your Form.\u00a0 I prefer this way…<\/p>\n

Step 1<\/h6>\n

Make sure all visible controls have been set for a Transparent background<\/p>\n

Step 2<\/h6>\n

Put an invisible Control in the Form’s Header, in this example it’s named\u00a0txtHighlightID and put the Primary Key in the Detail section and make that Control invisible also, in this example it’s named txtID.<\/p>\n

Step 3<\/h6>\n

In the Forms (yes, also works on Subforms) On_Current event put…<\/p>\n

Me.txtHighlightID = Me.txtID<\/p>\n

Step 4<\/h6>\n

Put a Control, it’s named txtHighlight in this example, that spans the full width of the Form…<\/p>\n

\r\n=IIf([txtID]=[txtHighlightID],"\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588\u2588","")\r\n<\/pre>\n
Set the Font Size to insure it goes the Height of the Row and select the color of the Font for your Control (this is what determines the color of the highlighting).\u00a0 In this example I used #F6FBDD.\u00a0 Make sure to go the Arrange<\/strong> tab, click on txtHighlight and click Send to Back<\/strong>.\u00a0 For how to\u00a0get the Full Block that is the highlight, see Conditional Row Shading on a Continuous Form<\/a>.<\/p>\n
Neaten up your Form and then preview… when you click on a row it will now highlight.\u00a0 You can download a sample here<\/a>.<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Highlighting the current record is an often asked question. You could use Conditional Formatting but then you have to do it for each Control in the Detail section of your Form. I prefer this way…<\/p>\n
 Step 1 <\/p>\n
Make sure all visible controls have been set for a Transparent background<\/p>\n
 Step 2 <\/p>\n
Put an invisible Control […]<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,63],"tags":[64,52],"class_list":["post-1029","post","type-post","status-publish","format-standard","hentry","category-access-tips","category-database-design","tag-access-tips","tag-row-shading","odd"],"_links":{"self":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1029","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1029"}],"version-history":[{"count":4,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1029\/revisions"}],"predecessor-version":[{"id":1173,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1029\/revisions\/1173"}],"wp:attachment":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}