Thanks Richard for your educative videos. I have never seen you used Classes in your videos. Classes are great as a developer. Makes code clean, easier to read and less codes.
I made a variation of this to highlight the background on continuous forms where the field boxes aren't all touching each other. It's basically the same except with an empty unbound text bound that sits behind the field boxes. I set this text box to enabled = false and locked = true, but the conditional formatting seems to override this. Clicking on the highlighted text box brings it to the front with the cursor blinking (but it's still locked). Kind of annoying and not sure if there's a fix
Hi Richard.. WHAT IF... I have a database with a T/F Check Box, what if I want to highlight either ALL [or in my case] just 3 of the OTHER fields red back? I've tried a few times to no avail..
Great videos Sir. I learned a lot. I have sub form to show all records after i click a submit/save button. Every thing is ok. But i want the focus on last record I saved except the first.
Dear Richard, thanks for the video but i got a problem with this one. I don't know why but only selected field is highlighted, just like usual conditional formatting. I literally checked many times the steps in the video and i'm sure that everything is the same(and it's even working in selected fields but not highlighting the whole row at once) but couldn't make it work like you did. I'm also sure that selectedID field automatically reflects the selected record ID. Do you have any suggestions about it?
Nice! I'm going to start incorporating this into databases I work on. It's a great way to bring the user's attention to the current record. Thanks!
Thanks Richard for your educative videos. I have never seen you used Classes in your videos. Classes are great as a developer. Makes code clean, easier to read and less codes.
Literally i was searching for this thanks a lot sir
This is so cool. Thanks for the tutorial!
Hi Richard that was a very good video very helpful I can use this in my database. Thank you Steve b
I made a variation of this to highlight the background on continuous forms where the field boxes aren't all touching each other. It's basically the same except with an empty unbound text bound that sits behind the field boxes. I set this text box to enabled = false and locked = true, but the conditional formatting seems to override this. Clicking on the highlighted text box brings it to the front with the cursor blinking (but it's still locked). Kind of annoying and not sure if there's a fix
Hi Richard.. WHAT IF...
I have a database with a T/F Check Box, what if I want to highlight either ALL [or in my case] just 3 of the OTHER fields red back?
I've tried a few times to no avail..
Great videos Sir. I learned a lot. I have sub form to show all records after i click a submit/save button. Every thing is ok. But i want the focus on last record I saved except the first.
Great video, THANK YOU! How to prevent flickering with conditional formatting on this scenario? Any tips?
Pretty handy trick...! 🙂👍
that was brilliant !
Dear Richard, thanks for the video but i got a problem with this one. I don't know why but only selected field is highlighted, just like usual conditional formatting. I literally checked many times the steps in the video and i'm sure that everything is the same(and it's even working in selected fields but not highlighting the whole row at once) but couldn't make it work like you did. I'm also sure that selectedID field automatically reflects the selected record ID. Do you have any suggestions about it?
Tough to tell from this side... post this in the Forum on my website with some screen shots. Maybe the guys and I can figure out what you did wrong.
Very useful, very clear = genius < Thank you
You're welcome
this is a+
Cant use VBA code where I work but this method was easy to recreate using the embedded macros.
👍
Great
thanks