View Full Version : space between characters


PC User
11-09-2007, 11:48 AM
Can the space between characters in any word or numbers in a text field in a report be increased using code? I have Access 2K.

Thanks,
PC

boblarson
11-09-2007, 12:31 PM
Yes, you could use the Replace function to do that, but it would add the same number of spaces to all of the places that had the number of spaces you define.

WayneRyan
11-11-2007, 11:23 PM
PC User,

Do you mean to alter the distance between characters in a textbox?

That is defined by the font, and other than changing fonts I don't think you
can do anything in code. It's not really an Access thing, it's a Windows topic.

A work-around would be to set the textbox's text alignment property to "distribute".
Then, by varying the width of the textbox, you'll alter the space between characters.

It would look kind of cool, but is it worth the trouble?

hth,
Wayne