Hi all! I need help on how I would be able to align justified my label text in reports. Please. Thanks
Hi all! I need help on how I would be able to align justified my label text in reports. Please. Thanks
move the label to where you want it.
set alignment to : left, right, or center.
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.
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.
Access does not have sophisticated text formatting capabilities like Word or Publisher. I very much doubt you will have success with this.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
You can't do thatSo If I I have to distribute the last word "eligibility".
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:
This would spread it nicely over 10 lines. Adjust the line breaks to suit your needs.Code: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."
Change the label name to whatever yours is
Thanks for the code. My label is not in the detail section. It is in the footer section. Will I do the same code?
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
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
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.