character spacing in report

[gagro]

I want to customize character spacing in report but do not know how. Please help

 

[Pat Hartman]

I'm not sure what you are looking for. Each control has a TextAlign property. Is that what you are after?

 

[gagro]

Thank You for helping me. I whant to customize characret spacing in a text box. For example "aaaa" is without spacing and "a a a a" have a single spacing between characters. It should be simple but I can´t find the way to do it. I need it to make some specific reports to put characrers in exact position with space between them as I need to..

 

[Pat Hartman]

If the alignment options don't work for you, you'll need to use VBA to create the string you want.

 

[gagro]

That is exactly what I am trying to do but I do not know how. I would be gratetfull if You can help me. So if You please send me the VBA code?

 

[Pat Hartman]

I don't have any sample that I can paste. If you want me to write the code for you, you will need to provide me with complete specifications (so far you haven't given any) and we will need to negotiate a price.

If you want to try to write it yourself, you'll need to use a Do loop and the Left(), Mid(), and Len() functions and possibly others. The Len() function will tell you how many characters the string contains so you will know how many iterations in your code loop. Left() and Mid() will let you pick up the current character and concatenate it into the string you are building.