Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Box surrounding the current record
- Thread starter zevw
- Start date
- Thread starter
- #3
- Thread starter
- #4
- Thread starter
- #6
- Thread starter
- #7
ppkgoldengun
MIS
Read the MSAccess Help:
Change the color of the control that has focus on a form
Open the form in Design view or Form view.
Make sure that the control is selected, and then, on the Format menu, click Conditional Formatting.
In the Condition x area of the Conditional Formatting dialog box, click Field Has Focus in the first box.
Select the font style, color, or other formatting that you want the field to have when it has focus.
Note When you open the Conditional Formatting dialog box, it displays the current default formatting for the selected control, including colors, font styles, and any expressions that you may have defined for the field.
OR
Write the VBA Code in the On Current Event to set the border type property of the fields to solid or change the color property.
Change the color of the control that has focus on a form
Open the form in Design view or Form view.
Make sure that the control is selected, and then, on the Format menu, click Conditional Formatting.
In the Condition x area of the Conditional Formatting dialog box, click Field Has Focus in the first box.
Select the font style, color, or other formatting that you want the field to have when it has focus.
Note When you open the Conditional Formatting dialog box, it displays the current default formatting for the selected control, including colors, font styles, and any expressions that you may have defined for the field.
OR
Write the VBA Code in the On Current Event to set the border type property of the fields to solid or change the color property.
- Thread starter
- #9
ppkgoldengun!
Took some time to respond.
Thank you for your lead there was a lot of work involved. But your idea was the clincher to my idea.
What I did at the end was I created a Text Box and a field in the table in the table called flag which is the control source for the text box. With on current event procedure I set the flag field to true and the previous record I set the flag to false. Now with the on conditional format I say if the flag = true then change the text box to black. This box is send to the back (behind) of all fields (controls) in the form. it is also one big text box that takes up the entire detail area of the form. It is a drop taller then all the other controls in the form and sticks a little out on the bottom and on the left and right side. so as soon as you enter the current record you see a black border around the whole current record and all other records have a slight white border around them.
Thanks for the lead, I have worked with conditional formatting in the past but did not know how it will work here.
Good Luck!!
Took some time to respond.
Thank you for your lead there was a lot of work involved. But your idea was the clincher to my idea.
What I did at the end was I created a Text Box and a field in the table in the table called flag which is the control source for the text box. With on current event procedure I set the flag field to true and the previous record I set the flag to false. Now with the on conditional format I say if the flag = true then change the text box to black. This box is send to the back (behind) of all fields (controls) in the form. it is also one big text box that takes up the entire detail area of the form. It is a drop taller then all the other controls in the form and sticks a little out on the bottom and on the left and right side. so as soon as you enter the current record you see a black border around the whole current record and all other records have a slight white border around them.
Thanks for the lead, I have worked with conditional formatting in the past but did not know how it will work here.
Good Luck!!
- Status
Similar threads
- Locked
- Solved
- Question
- Locked
- Question
- Locked
- Question
