Dragan,

The MaxLength value changes to the size of the Char field. So, if you revert back to a Memo field, you have to explicitly change the MaxLength value back to zero (0).

Hope to help.

Dennis



>>>I'm trying to write a bit of a general tool for some data maintenance, and among other things I have a few methods which do some string cosmetics on various fields. The field currently worked on is a controlsource of a largish editbox. However, there's a combo where, in .interactiveChange(), the controlsource of the editbox can be set to any of the available fields (any memo or c(n) for n>=40). The editbox is refreshed after change.
>>>
>>>The trouble with this is that setting the controlsource to, say, a c(44) field seems to set maxlength to 44 - the memo loaded next is chopped at this length. This doesn't happen if I've only viewed the shorter field; however, after some typing into it, the editbox seems to get a maximal length equal to 44.
>>>
>>>Anyone know any tricks that may help here? Setting the controlsource to none and value to "" before assigning the controlsource, maybe? Or would I be better off with separate controls for C(n) and M fields?
>>
>>Just an idea to try - play with BindControls property of the form. Not sure if it can help with the problem, but it's worth a quick try.
>
>Thought of that, but it's a one-time delayed thing, i.e. works only once. Setting it to .f. will not unbind controls so that they may be re-bound again.
>
>Anyway, drilling down the specs I've found that I need to do different stuff with the c(n) and memo fields, so duplicating the controls actually wouldn't be quite duplicating - the commandbuttons would be different, so this is solved. Just if someone has this problem again, I had it first ;) (or just couldn't find a predecessor)