Full Justification in MS Access Report

[jessieh]

I need to make a 3 column report for a magazine.&nbsp;&nbsp;I need to have the columns with full justification.&nbsp;&nbsp;I have tried text alignment, but can only find left, right, center, and general.&nbsp;&nbsp;I have also tried exporting the report as an RTF file, but it changes the formating quite a bit.<br><br>Any help appreciated.<br><br><A HREF="mailto:jhagan@sar.org">jhagan@sar.org</A>

 

[DougP]

So what's the data, what's it doing, and what do you want it to do.<br>Is it Text? a number? a date? a composite of several fields.<br><br>Do you want leading zeros or space padding??<br><br>values 1233 341313<br>Need it to be <br>00000001233<br>00000341313<br><br><br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[elizabeth]

You can concatenate leading or trailing blanks or zeros with the &, like:<br>&quot;0000&quot; & strData & &quot;000&quot; <br>but if you are talking about justifying as in word processing where you insert additional blank spaces between words you'd have to write a custom function.