Hi Cetin,

Is it possible to reformat the display in a text box. As an example, I have a CHAR field but would want to display the first 5 CHAR out of 15 CHAR. The controlsource in text box does not allow me to specify any function expression. Another thing, how to change the colour of the background based on values in the control source. Thanks.

Regards,
Kueh.

>>Dear all,
>>
>>Does anyone know if it is possible to have a container object that will display data from a grid object. The container object I have contains three text boxes and the grid column is bound to a CHAR field of a table that is a concatenation of three separate strings. An example is "AAC|BIL|CLN" What I am trying to do is to put the three strings into the text box of the container. Is this possible? Thanks.
>>
>>Regards,
>>Kueh.
>
>Kim,
>It's possible to have a container in grid column. What is hard is to make it behave as you want at times. If the textboxes inside the container doesn't have a controlsource you'll see that as one textbox is changed in a row, it changes in all rows. However if you bind them to controlsources then works as expected. At least you could create a dummy cursor and bind their controlsources to cursor's fields.
>I suggest whatever type container is you're going to put there make it a class. Because it's hard to change something in container once it's put in a column (I mean it's harder to reach to PEM as hierarchy level gets deeper).
>Cetin