Letter from field

[Pavel Smirnov]

My situation is: I have blank form, and I need to put each letter from Last Name or other to each cell in a blank form. So, FM11 doesn't have text spacing. How I can do this?

Maybe I need to make another fields with calculation and paste spaces between letters? If it's the best way, please say how to this calculation.

And another way that I think is make fields for each cell and make calculation for these fields equally each letter of LastName.

So and I have dates that i need to put it over cels like -date dd month mm year yyyy. How make it? I really need it.

If you have another advices I'll be glad see it. Please, help.

P.S. I put blank form, it help you imagine what I need.

[comment]

Try a repeating calculation field =

Middle ( Extend ( YourField ) ; Get ( CalculationRepetitionNumber ) ; 1 )

[Pavel Smirnov]

Try a repeating calculation field =

Middle ( Extend ( YourField ) ; Get ( CalculationRepetitionNumber ) ; 1 )

Thanks, it helps,

but I do not like that i need to create a lot of additional fields.

[comment]

I believe you could make it all in one field - something like:

Let ( [

w = 25 ; 

pad = Substitute ( 10^w - 1 ; "9" ; " " ) ;



text =

Left ( Extend ( Name ) & pad ; w )

&

Left ( Extend ( StreetAddress ) & pad ; w )

&

Left ( Extend ( City ) & pad ; w )

&

...



] ;

Middle ( text ; Get ( CalculationRepetitionNumber ) ; 1 ) 

)

[Pavel Smirnov]

I believe you could make it all in one field - something like:

Let ( [

w = 25 ; 

pad = Substitute ( 10^w - 1 ; "9" ; " " ) ;



text =

Left ( Extend ( Name ) & pad ; w )

&

Left ( Extend ( StreetAddress ) & pad ; w )

&

Left ( Extend ( City ) & pad ; w )

&

...



] ;

Middle ( text ; Get ( CalculationRepetitionNumber ) ; 1 ) 

)

Excellent, Thank you, Consultant. You are my hero)

[Vaughan]

There is a usability problem with the sender naming on the posts, because the poster name is in the grey "title bar" of the message while the "tag" (for want of a better word) appears prominently under the avatar image where the user name would be expected.