Textboxes right margin (1 Viewer)

basilyos · Sep 25, 2017

Hello guys

I have a report in arabic (reading order = right to left)
In the detail section i have 7 textboxes and a big one that contains all the data of the 7 textboxes and i used a small function to concat textboxes

My problem with the right margin the first letter doesn't appear
I changed the right margin in the 7 textboxes and then in huge one and then in all the 8 textboxes
Then i put the data source of the textboxes before the data
= "5 spaces" & [Data]

Everything omay with the first line but i a textbox with more than one line so the second line will start from zero

Any solution so all the text start from the new right margin value

Minty · Sep 25, 2017

Have a look into the right padding option - this will move the inner margin of the entire control.

basilyos · Sep 25, 2017

I tried the right margin nothing happened still have the same problem

Sent from my SM-J510F using Tapatalk

Minty · Sep 25, 2017

Not the margin - the padding - it's a different setting.

basilyos · Sep 25, 2017

Minty said:
Not the margin - the padding - it's a different setting.

Yes yes sorry for mistyping i tried the right padding

Sent from my SM-J510F using Tapatalk

Minty · Sep 25, 2017

Can you upload the form and some simple sample data to demonstrate, and maybe a picture of what you are trying to achieve?. The padding setting definitely works normally.

basilyos · Sep 26, 2017

hello sir
i uploaded a sample of my database
and i put two reports right and left

the left one contains textbox that have left alignment no problems
but the right one contains textbox that have right alignment the first letters of each textbox gone

i already said that i have multiple textboxes in one textbox

any solution ??

Minty · Sep 27, 2017

Firstly I would remove the leading spaces - if you click in the hidden text boxes, on my machine at least, when you scroll through the contents the spaces tab through left to right but when you reach the stored text the text it goes right to left, so that might be causing some confusion.

basilyos · Sep 27, 2017

Minty said:
Firstly I would remove the leading spaces - if you click in the hidden text boxes, on my machine at least, when you scroll through the contents the spaces tab through left to right but when you reach the stored text the text it goes right to left, so that might be causing some confusion.

the original textboxes show the text with no problems in the first letters just in the concat textbox

so can we make something in the function

Code:

Public Function fnConcat(ParamArray p() As Variant) As String
    Dim elem As Variant
    Dim ret As String
    For Each elem In p
        If Trim(elem & "") <> "" Then ret = ret & elem & vbCrLf
    Next
    If Len(ret) > 0 Then ret = Left(ret, Len(ret) - Len(vbCrLf))
    fnConcat = ret
End Function

basilyos · Sep 27, 2017

any help please ??????

arnelgp · Sep 27, 2017

check if there are changes.

basilyos · Sep 27, 2017

arnelgp said:
check if there are changes.

no sir nothing changed in the right report the same problem exist the first letters disappear

basilyos · Sep 28, 2017

Any help guys?
I really need a solution
I gues the problem in the concat function
If so can i use another function and have the same result (combine textboxes each one on a new line) without losing first letters when i change the align to the right?

Sent from my SM-J510F using Tapatalk

basilyos · Oct 2, 2017

Any help guys?
Please i really need the solution

Sent from my SM-J510F using Tapatalk

Textboxes right margin (1 Viewer)

basilyos

Registered User.

Minty

AWF VIP

basilyos

Registered User.

Minty

AWF VIP

basilyos

Registered User.

Minty

AWF VIP

basilyos

Registered User.

Attachments

Minty

AWF VIP

basilyos

Registered User.

basilyos

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Attachments

basilyos

Registered User.

basilyos

Registered User.

basilyos

Registered User.

Similar threads

Users who are viewing this thread