Using the return key with KeyPress Event

[colin]

Hi All,

Can anyone tell me how I could capture the "Return Key" when using the KeyPress Event. I want the user to be able to type a string into a text box and once they press the return key for it to activate a given piece of code.

Many thanks,

Colin

[honeybee]

You could write code in the KeyPress event to trap the KeyAscii = vbKeyReturn. And do you have any command button set to Default? If so, set the .Default property to False.

.

[colin]

Many thanks,

that worked a treat.

Colin