Continuous Form Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave the Wave - 22 Nov 2005 19:25 GMT

I'm trying to control the appearance of a control (textbox) only when it
has focus. I set up [control name]_Enter and [control name]_Exit routines
which accomplish exactly what I want, except, all instances of the control
are changed instead of only the one with the focus.

Any help will be greatly appreciated! Thanks

Reply to this Message

fredg - 22 Nov 2005 21:01 GMT

> I'm trying to control the appearance of a control (textbox) only when it
> has focus. I set up [control name]_Enter and [control name]_Exit routines
> which accomplish exactly what I want, except, all instances of the control
> are changed instead of only the one with the focus.
>
> Any help will be greatly appreciated! Thanks

That is correct on a Continuous Form.
If you have Access 2000 or newer, depending upon what it is you wish
to do, you might be able to use the control's Conditional Formatting
property.
Select the control.
Click on Format + Conditional Formatting.
Set the Condition1 drop-down to When Field Has Focus.
Then select whatever formatting is available.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Dave the Wave - 22 Nov 2005 22:57 GMT

>> I'm trying to control the appearance of a control (textbox) only when
>> it has focus. I set up [control name]_Enter and [control name]_Exit
[quoted text clipped - 11 lines]
> Set the Condition1 drop-down to When Field Has Focus.
> Then select whatever formatting is available.

Thanks much for youe help. Interestingly enough, If I only change the
width of the control, only the active instance of the control has its
background color extended. In other words, although the width of all
instances of the control is increased, the background color on the
screen only gets refreshed in the active instance. The remaining
instances look as if nothing had been changed. (I'm guessing this has
something to do with the way Access modifies only the active control
when it gets focus for typing text????)

Reply to this Message