>You can use textboxes to bind to a memo field, but not directly. Instead of using ControlSource, you have to put code in lostfocus and refresh events like:
>
>REfresh()
>THIS.Value = ALLTRIM(MyView.MemoField) && Alltrim converts it to char
>
>LostFocus()
>REPLACE MyView.MemoField WITH THIS.Value
You could then limit the input with a mask. If this were to be the preferred way of handling varchar2 fields, one could create a Memo Textbox class with the [modified] code you suggested to make it reusable. Then add a property to the class to store the
view.field source of the textbox.
I leave it to the reader to figure out how to make Erik's code generic for any view and fieldname. This is becoming a good, and more palatable, solution to the varchar2 issue in Oracle.
Now if we could just resolve the problem of passing a parameter list to an IN clause of a remote view of an Oracle table.
Mark McCasland
Midlothian, TX USA