Aligning label text to Align Justified

[VicLetran]

Hi all! I need help on how I would be able to align justified my label text in reports. Please. Thanks

[ranman256]

move the label to where you want it.
set alignment to : left, right, or center.

[isladogs]

move the label to where you want it.
set alignment to : left, right, or center.

Or set to Distribute which spreads the text to fill the space - rarely any use but its available

[VicLetran]

Thanks for the reply but it still doesn't work. My text is like a paragraph 5 lines and the last line is only one word. So If I I have to distribute the last word "eligibility".

My Label is this :

The said order shall automatically cease upon its expiration as stipulated above, unless renewed. However, services of any or all of the above-named can be terminated prior to the expiration of this Job Order for lack of funds or when their services are no longer needed. The above-named hereby attests that he or she is not related within the third degree (fourth degree in case of LGUs) of consanguinity or affinity to: 1) hiring authority and/or 2) representatives of the hiring agency; that he/she has not been previously dismissed from the government service by reason of an administrative offense; that he/she has not yet reached the compulsory retirement age of sixty five (65). Furthermore, the service rendered is not considered or will never be accredited as government service. That he/she has not been found to possess spurious or fake eligibility.

[VicLetran]

Thanks for the reply but it still doesn't work. My text is like a paragraph 5 lines and the last line is only one word. So If I I have to distribute the last word "eligibility".

My Label is this :

The said order shall automatically cease upon its expiration as stipulated above, unless renewed. However, services of any or all of the above-named can be terminated prior to the expiration of this Job Order for lack of funds or when their services are no longer needed. The above-named hereby attests that he or she is not related within the third degree (fourth degree in case of LGUs) of consanguinity or affinity to: 1) hiring authority and/or 2) representatives of the hiring agency; that he/she has not been previously dismissed from the government service by reason of an administrative offense; that he/she has not yet reached the compulsory retirement age of sixty five (65). Furthermore, the service rendered is not considered or will never be accredited as government service. That he/she has not been found to possess spurious or fake eligibility.

[June7]

Access does not have sophisticated text formatting capabilities like Word or Publisher. I very much doubt you will have success with this.

[isladogs]

So If I I have to distribute the last word "eligibility".

You can't do that
The entire label has to be formatted in the same way - general/left/right/centre/distributed

I do complex formatting using code
If the label is in the detail section, add code similar to this to the Detail_Format event:

Me.MyReportLabelName.Caption = "The said order shall automatically cease upon its expiration as stipulated above, unless renewed." & vbCrLf & _
"However, services of any or all of the above-named can be terminated prior to the expiration of this Job Order for lack of funds or when their services are no longer needed. " & vbCrLf & _
"The above-named hereby attests that he or she is not related within the third degree (fourth degree in case of LGUs) of consanguinity or affinity to:" & vbCrLf & _
"1) hiring authority" & vbCrLf & _
"and/or" & vbCrLf & _
"2) representatives of the hiring agency;" & vbCrLf & _
"that he/she has not been previously dismissed from the government service by reason of an administrative offense;" & vbCrLf & _
"that he/she has not yet reached the compulsory retirement age of sixty five (65)." & vbCrLf & _
"Furthermore, the service rendered is not considered or will never be accredited as government service." & vbCrLf & _
"That he/she has not been found to possess spurious or fake eligibility."

This would spread it nicely over 10 lines. Adjust the line breaks to suit your needs.
Change the label name to whatever yours is

[VicLetran]

Thanks for the code. My label is not in the detail section. It is in the footer section. Will I do the same code?

[isladogs]

Yes - just use the Format section containing your label.

I use the idea regularly including more complicated text strings with function outcomes & it works well

[June7]

Sometimes I use a textbox with an expression to serve as a "label". So VBA would not be needed:

="ABC" & Chr(13) & Chr(10) & "DEF"

Just ran across Lebans utility for justifying which you might find interesting: http://www.lebans.com/xjustifytext.htm