autoexpand

[tbeers]

Quick questions

Is there a way to create an autoexpand property in a text or memo field?

Thanks

Tomb

[Stewart Ross]

Hi Tom B. If it is a facility like combo box auto expand you are asking about (where the characters typed in the combo box are automatically matched to entries in the combo's recordsource), short answer is no. Unlike a combo box a textbox has no recordsource to match against, so there is no defined set of entries against which it could expand the keystrokes entered

Whilst it is possible to use the keystroke events (key down, key up, key press) to create custom behaviours for a textbox which might include some form of expansion against a recordset, the effort involved is unlikely to be matched to much in the way of useful reward, and is certain to be slower than the performance of the built-in combo text expansion.

If you need such functionality, you'd be better off just using a combo box directly for this purpose instead...

-Stewart