I am making a report which has long text in one field (paragraphs of writing). I don't love the 'distribute' option and would prefer 'justified' text. Is there a way to make that happen?
-
-
To the best of my knowledge, justified text format is not natively supported within Access.
There may be a VBA implementation; however, I've not seen this code. Justified text requires being able to pull the kerning information from the font file; thus, if someone could figure that out, then we've a money maker on our hands!
If you truly need this, then you may have to either resort to using word (either via automation, links etc...) or purchase one of the commercial products. -
As Zmbd states, access has (to my knowledge) no native support for text justification.
Stephan Leban has made a free active X control that might be worth looking into. I have never tried it myself, but I have tried other bits of his code, with satisfaction.
You can try looking at it here:
Lebans Active X Control for Text justification
Be aware though, that he has retired and if you plan to move to 64bit access anytime soon I doubt the active X component would continue to function.Comment
-
Just to clarify what is being requested here I thought I'd post this explanation :- Distribute = Spread the characters displayed in every line such that the inter-character spacing is uniform across the line.
- Justify = Spread the words displayed in every line such that the inter-word spacing is uniform across the line.
Comment
Comment