Box surrounding the current record

[zevw]

I would like to create a rectangular box surrounding only the current active record and not the inactive records.

Any help on this would be appreciated!!

Thanks in advance!

 

[sfreeman]

more info please.

Sam_F
"90% of the problem is asking the right question.

 

[zevw]

Instead of using the default Record Selector I would like to have a box surrounding the active record on the form which would show the user the active record.

 

[zevw]

PLEASE ANYONE SOME IDEA ON THIS!!

 

[PHV]

Perhaps conditional format ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[zevw]

Can you elaborate!!

 

[zevw]

Can you elaborate!!

How you would set the conditional formatting?

 

[ppkgoldengun]

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.

 

[zevw]

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!!