Jeff,
With proper formatting the data in column should look aligned if you change texbox font to non-proportional, Courier New, for example. BTW, I guess
Str(table.numfield,'#########.##')+ ...
TRANSFORM(table.numfield,'#########.##')+...right?
>Hello,
>
>I want to display information from 2 fields of a table in 1 column of a grid. The first one is a numberic value and the second is a character.
>
>I have accomplished this trough setting the columns controlsource to
>"Str(table.numfield,'#########.##')+SPACE(1)+table.charfield" but now my problem is alignment. I need to left justify the charfield and right justify the numfield.
>
>Example:
>
>-100 lf
>2500 EA
>
>Is there another control that I can put in the column of the grid that would give me more formatting flexibility that a text box?
>
>Any help is truly appreciated.
>
>Thanks,
>
>Jeff
--sb--