Textboxes right margin

B

basilyos

Registered User.
Local time
Today, 11:09
Joined
Jan 13, 2014
Messages
256
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
 
Have a look into the right padding option - this will move the inner margin of the entire control.
 
I tried the right margin nothing happened still have the same problem

Sent from my SM-J510F using Tapatalk
 
Not the margin - the padding - it's a different setting.
 
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.
 
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 ??
 

Attachments

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.
 
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.
Click to expand...

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
 
check if there are changes.
 

Attachments

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
 
Last edited:
Any help guys?
Please i really need the solution

Sent from my SM-J510F using Tapatalk
 
You must log in or register to reply here.

Similar threads

H
Solved Textbox "format" dropdown not working in properties in form design view
Replies
12
Views
477
GPGeorge
GPGeorge
oxicottin
Solved Running sum based off another text box value
Replies
11
Views
513
Pat Hartman
P
T
Solved Sum the data in a textbox in continous form
Replies
12
Views
658
TMK
T
C
Invalid use of Me.
Replies
8
Views
412
cheekybuddha
cheekybuddha
C
Subform Footer Textbox wont update
Replies
11
Views
415
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom