got focus() or lost focus()

Question

hiii morning

could you please tell me how to code in VBA if i am working in the form field so it's color should turn blue and when i move to next field then it should be white again.

thankx

Answer 1

You don't need VBA for that - you can use conditional formatting.

Open the form in design view.

Select the text box or combo box.

Select Format | Conditional Formatting...

Select Field has Focus from the dropdown under Condition 1.

Specify the formatting that you want (blue)

Click OK twice.

Answer 2

Thanks, my memory of Access 2003 and before is fading.

Answer 3

Not only will Hans' approach do the job without code, but you can, in Design View , select all Textboxes you want this behavior to occur in then go thru the steps given above once, rather than having to put code in the GotFocus/LostFocus events of each separate control.

Also, for Datasheet and Continuous View Forms Conditional Formatting is the only way to perform this kind of formatting.

BTW, in 2003 there is no Click Format step, you simply specify the formatting that you want. And you only need toClick OK once. Hans apparently is running a version other than 2003.

Linq ;0)>

---

There's always more than one way to skin a cat!

Answer 4

Why not? It's a much easier way to change the color of a control while it has the focus than using VBA.

Answer 5

sorry i don't need any conditional format.