how to justified text in report ms access

Question

hi guys..

how can i justified text in report in ms access

i maked example in ms word

Answer 1

Set the Text Align property of the text box on the report to Distribute.

Warning: there is a bug in this setting - the last line of the text box will be justified too.

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 2

Is there another way? VBA codes for example

Answer 3

It will essentially be the same thing, setting the TextAlign property of the Textbox, so it make a lot more sense to do so once and save the setting directly in your report design rather than to do it in VBA.

Me.YourControlName.TextAlign = 4

---

Daniel Pineault, 2010-2018 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net