Sendkey Question

[Randix]

I have a form with one text field and multiple memo fields. I want the memo fields to expand whenever user enters them. I've tried Sendkeys "+{F2}" and it works when user first enters. However, why when you leave the field, and then return to that same field, it doesn't work again?

 

[Fornatian]

Where have you put the code?

As I recall I think it should be in the OnGotFocus or OnEnter event-probably OnEnter thinking about it.

 

[Rich]

Send keys are not the best way to do this use the DoCmd.RunCommand method.
HTH

 

[Randix]

Rich--use the DoCmd.RunCommand in conjunction with what? Sendkeys "+{F2}"?