Highlighting Rows - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Highlighting Rows

Serdar Sahinbas

2 years ago

As original thread is closed, i had to create this new conversation. I got a problem with highlighting rows which is showed in Richard's original video on Youtube. I don't know why but in my DB, 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 as it should. I'm also sure that selectedID=RecordID in Form_Current event as the SelectedID text box automatically reflects the selected record ID. Any suggestions?

	Serdar Sahinbas OP @Reply 2 years ago

	Serdar Sahinbas OP @Reply 2 years ago

	Serdar Sahinbas OP @Reply 2 years ago

	Richard Rost @Reply 2 years ago
Well, aside from the fact that I can't read the language, it looks OK to me. Does MY database work on your system when you download it?

	Kevin Yip @Reply 2 years ago
Is "SelectedID" the correct name for the textbox? Also, check each textbox's formatting rules individually. Some of the textboxes may have other rules that are interfering.

	John Davy @Reply 2 years ago
Hi Serdar Also check the order of your conditional formatting rules. Richard covers that. John

Serdar Sahinbas OP @Reply

2 years ago

Thank you for all the comments.

@Richard, sorry for the native language but yes your DB works perfectly fine. I made the changes in customer form of your free template DB and whole row is highlighted as it should be. It is definetely about my DB, but can't see the reason yet. I will keep investigating.

@Kevin, yes, SelectedID is the correct name of textbox. It also reflects the current ID of the selected record. I will check if there is an individual rule of these textboxes that may interfere.

@John, i will now go and watch Richard's conditional formatting video!

	Serdar Sahinbas OP @Reply 2 years ago
Result: I found the problem and fixed it. <B>It was about backstyle of textboxes in form. They were set to transparent so this was interfering with conditional formatting. I switched them back to "normal" and now everything works perfectly fine!</B> Thanks for the comments helping me to detect this problem.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View