Hi all,

On a form there are 3 rows consisting of 5 controls each row. After
inputting, these contents of the controls should also be aligned up neatly in
a merged range cell in the following format:

Row1Field1 Row1Field2 Row1Field3 Row1Field4 Row1Field5
Row2Field1 Row2Field2 Row2Field3 Row2Field4 Row2Field5
Row3Field1 Row3Field2 Row3Field3 Row3Field4 Row3Field5

I can use space() to make each column have same number of character, but
because each char'width is different, for example "1" and "w", so there is
still some
position shift. How can I overcome it?

Clara

--
thank you so much for your help

Without gettin fancy - you could just use a monospaced font like courier!

The simple answer would be do not use a merged cell.
Then no solution necessary as there is no problem.

NickHK

"clara" wrote in message
...
Hi all,

On a form there are 3 rows consisting of 5 controls each row. After
inputting, these contents of the controls should also be aligned up neatly
in
a merged range cell in the following format:

Row1Field1 Row1Field2 Row1Field3 Row1Field4 Row1Field5
Row2Field1 Row2Field2 Row2Field3 Row2Field4 Row2Field5
Row3Field1 Row3Field2 Row3Field3 Row3Field4 Row3Field5

I can use space() to make each column have same number of character, but
because each char'width is different, for example "1" and "w", so there is
still some
position shift. How can I overcome it?

Clara

--
thank you so much for your help

Hi Ben,

Courier is ok, but it is a little abnormal. Could you tell me another kind
of font more like normal one?

Clara

thank you so much for your help


"Ben McBen" wrote:

Without gettin fancy - you could just use a monospaced font like courier!