Justified text in textbox

[Bradon]

When I use "Distribute" as the setting for text align I have problems with lines that only contain a few words - access evenly spaces each letter accross the entire width of the textbox.

Is there any way to force short lines to be "left" align?

 

[Norie]

I suppose you could use code to check the length of the text and change the property appropriately.

It would need to be triggered by some event.

Which one would depend on where this textbox is located, a form, report etc.

 

[Bradon]

The textbox is on a report. Apart from the form opening in preview there is no other action apart from the print command.

Any suggestions as to the code?

 

[tails]

cant you just do what you do in word...
dont get me wrong i've not completely sure but i thought this might help
couldn't u just highlight the short sentances and click the left align button?
not too sure on this its not really my field of work. but just try it, it might just be what u were looking for

 

[Bradon]

Nice try, but the textbox is drawing on several fields for its content. Access isn't quite as flexible as word for formatting.

This one is for the geniuses who can write "R ray: eal Code"