Conditional formatting in continuous forms

  • Thread starter Thread starter Leonard Priestley
  • Start date Start date
L

Leonard Priestley

I have a continuous form in which I am using conditional formatting to
highlight the field that has the focus. The checkbox control does not have
provision for changing its colour, so I put a small box around it and
attempted to change the colour of the box, depending on whether or not the
checkbox has focus. My problem is that when I click on one checkbox, it
changes colour in all the records, not just the one I click on.

My code for the checkbox gotfocus and lost focus events is of the form:
box.BorderStyle = 0 (i.e. Transparent), and
box.BorderStyle = 1 (i.e. Solid)

Can someone point me in the right direction please.

Leonard Priestley
 
Remove the code. Instead, use Conditional Formatting from the Format menu
(in form design, with the text box selected). Use an Expression to change
the format for the text box, depending on the value of the text box.

This is only available in Access 2000 and later.
 
Back
Top