>Hi,
>
>I have a grid in a Form to display a table, one of the field is
>6 char. long, but I want to add two digits before to display it.
>eg. TABLEA
> Field1 6 char.
>
>the value of Field1 is "123456",
>I want to display it on the grid is "FX123456"
>
>How can I do it ?
>
>Please give advise.
>
>Thank.
>Derek
Just set the column's controlsource to be "FixedPart" + field. This would make the column read-only, though.
If it's not broken, fix it until it is.
My Blog