 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / January 2007highlight record in form
I have a form that is set to 'Continuous Forms'. I need to have the entire "Record" highlighted. The reason is that I also have an subform attach which contains centain information that I transfer to related fields in the Parent form through a button. How do I have the entire record highlighted. Generally speaking if you have a code in the first field of the record such as Me.Field.BackColor = VbRead the entire field will change. I want to have the record or line highlighted. This will be easier to know that the information will be transferred to the proper record and field. How can this be accomplished? Sandrao > I have a form that is set to 'Continuous Forms'. I need to have the entire > "Record" highlighted. The reason is that I also have an subform attach which [quoted text clipped - 6 lines] > How can this be accomplished? > Sandrao Access 2002 or newer? See http://www.lebans.com specifically: http://www.lebans.com/conditionalformatting.htm You can down load a sample database that includes various uses for shaded lines, including continuous form alternating lines and highlighting the selected line.  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail >I have a form that is set to 'Continuous Forms'. I need to have the entire >"Record" highlighted. The reason is that I also have an subform attach which [quoted text clipped - 4 lines] >the record or line highlighted. This will be easier to know that the >information will be transferred to the proper record and field. Add a hidden text box (named txtKey) to the form's header section. Then add a line of code to the form's Current event procedure: Me.txtKey = Me.pkfield With that in place, you can use Conditional Formatting on any/all of the text boxes in the detail section. Set the Expression Is option to [pkfield] = [txtKey] Probably a better way to highlight the entire detail is to add a text box to the detail section. Size it the same as the detail section and use Send to Back to place it behind all the other controls. Then use CF for just this one text box. You probalbly will also want to set the other text box's BackStyle to Transparent. SignatureMarsh MVP [MS Access] Thanks your suggestion works well. Just one little silly question. How do you Send to Back ? > >I have a form that is set to 'Continuous Forms'. I need to have the entire > >"Record" highlighted. The reason is that I also have an subform attach which [quoted text clipped - 20 lines] > box. You probalbly will also want to set the other text > box's BackStyle to Transparent. Select the text box, then use the Format - Send to Back menu item. SignatureMarsh MVP [MS Access] >Thanks your suggestion works well. Just one little silly question. > [quoted text clipped - 24 lines] >> box. You probalbly will also want to set the other text >> box's BackStyle to Transparent. Thanks all works fine > Select the text box, then use the Format - Send to Back menu > item. [quoted text clipped - 27 lines] > >> box. You probalbly will also want to set the other text > >> box's BackStyle to Transparent. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.