View Full Version : character spacing in report


gagro
07-04-2005, 07:06 AM
I want to customize character spacing in report but do not know how. Please help

Pat Hartman
07-04-2005, 01:36 PM
I'm not sure what you are looking for. Each control has a TextAlign property. Is that what you are after?

gagro
07-05-2005, 03:48 AM
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
07-05-2005, 12:54 PM
If the alignment options don't work for you, you'll need to use VBA to create the string you want.

gagro
07-11-2005, 04:05 AM
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
07-11-2005, 05:52 PM
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.