justified allignment

[MeU&Us]

hi! any one can help me pls!
how to justify text in memo field of a form and a report? i need some sort of code that keeps the text in memo field justified. there are only 3 options of text align, right,left, distributed. i want justify property. how to get that. pls help me out!!!

 

[SpentGeezer]

hi! any one can help me pls!
how to justify text in memo field of a form and a report? i need some sort of code that keeps the text in memo field justified. there are only 3 options of text align, right,left, distributed. i want justify property. how to get that. pls help me out!!!

By Justified you mean this:

"Justified" - Sort of a mix between the other types. Text begins aligned to the left, but lines will "extend" themselves (by increasing the space between words) in order to completely fill the line with text. This type of alignment wants both the left and right sides of text to have straight edges.

http://wiki.answers.com/Q/What_is_justified_alignment#ixzz1CfIH4Nqq​

I don't think this can be done. Do you know that text boxes in the report have "can grow" and "can shrink" properties. These are useful for tidying up your report.

 

[missinglinq]

What is normally known as 'justified,' i.e. text aligned so that it covers the entire line, touching both left and right borders, is what Access calls 'distributed.'

 

[MeU&Us]

there should have been some way !

 

[MeU&Us]

but in distributed property, the last line of memo field is also distributed which doesnt look good. may there is someway, so that all but the last line is distributed, some sort of code!!!

 

[boblarson]

but in distributed property, the last line of memo field is also distributed which doesnt look good. may there is someway, so that all but the last line id distributed, some sort of code!!!

No, it is either or.

 

[MeU&Us]

i guess, there is no way to do that.

 

[MeU&Us]

what about you, Bob, there should be some way

 

[MeU&Us]

what about lebans solutions

 

[MeU&Us]

what about the code at following link
http://www.lebans.com/xjustifytext.htm
i tried to figure it out, but could not understand! can someone ll look at it please and reply me!

 

[boblarson]

what about you, Bob, there should be some way

No, really there isn't. A text box can have only one justification. No more. It might be possible with a Rich Text box but I don't know and it would rely on you having a hard return for the last line instead of wrapping and that could make other problems for you down the line.

 

[missinglinq]

Bob's right, it really is all or none! The problem, of course, would be identifying exactly what comprised the 'last line.'

I think the only way to really do this would involve using a monospace font (one where every letter has the same width) figuring out how many characters would be displayed per line, based on the width of your textbox, then dividing the length of the field by this character count, then using the 'remainder' as the length of the 'last line.'

You'd then have to parse all of the field except this 'last line' segment, apply Distributed Alignment to it, and tack on the 'last line' usimg a normal alignment.

All in all, way more work than it could possible be worth! You are, after all, talking about a database form or report, not the invitations to a royal wedding!

 

[MeU&Us]

thanks for help!