Alignment of text (1 Viewer)

L

luzz

Registered User.
Local time
Today, 04:37
Joined
Aug 23, 2017
Messages
346
arnelgp said:
did you rename the Textbox Control?
rename it to something Other than
the FieldName on your table.
(Property->Other->Name)

also i gave you this:

=LeftAligned([theFieldName], 2)

replace [theFieldName] with the
fieldname on your table.
Click to expand...

yes i did, i change it to txtComment.

My control source = LeftAligned([Remarks], 2)
 
Minty

Minty

AWF VIP
Local time
Today, 12:37
Joined
Jul 26, 2013
Messages
10,371
@arnelgp - I think Luzz has mislead you - I think (and it's why I and others asked for how he created the remarks field) that the start of the text is "Reason Stated :" & some other fields.

This could be more easily fixed if the Reason Stated: was a label for the text box.
 
L

luzz

Registered User.
Local time
Today, 04:37
Joined
Aug 23, 2017
Messages
346
Minty said:
@arnelgp - I think Luzz has mislead you - I think (and it's why I and others asked for how he created the remarks field) that the start of the text is "Reason Stated :" & some other fields.

This could be more easily fixed if the Reason Stated: was a label for the text box.
Click to expand...

How do i fix if i am using just a textbox?
 
Minty

Minty

AWF VIP
Local time
Today, 12:37
Joined
Jul 26, 2013
Messages
10,371
Well for the third time of asking - how are you creating the remarks field? What is the SQL in the query ?
Text please, not a picture.
 
L

luzz

Registered User.
Local time
Today, 04:37
Joined
Aug 23, 2017
Messages
346
Minty said:
Well for the third time of asking - how are you creating the remarks field? What is the SQL in the query ?
Text please, not a picture.
Click to expand...

how are you creating the remarks field?
- The remarks in my report come from my database, which i set the data field in my database for remark as "long text" as my remarks is very long.

What is the SQL in the query ?

SELECT mxd.FabricDelivery, mxd.Fabrication, mxd.Width, mxd.FinishedGoods, mxd.Colour, mxd.LabDipCode, Sum([mxd.GrossWeight]) AS TotalGrossWeight, Sum([mxd.NettWeight]) AS TotalNettWeight, Sum([mxd.Yds]) AS totalYds, mxd.Fabrication, mxd.MXDPO, Sum([mxd.Loss]) AS TotalLoss, First([mxd.Remarks]) AS Remarks, Min(mxd.GLGPO) AS MinOfGLGPO
FROM mxd
GROUP BY mxd.FabricDelivery, mxd.Width, mxd.FinishedGoods, mxd.Colour, mxd.LabDipCode, mxd.Fabrication, mxd.MXDPO
HAVING (((Min(mxd.GLGPO))=[Enter 1st GLGPO] Or (Min(mxd.GLGPO))=[Enter 2nd GLGPO]));
 
Minty

Minty

AWF VIP
Local time
Today, 12:37
Joined
Jul 26, 2013
Messages
10,371
But you said earlier that every remarks field starts with "Reason Stated: ", does this get typed in by the user followed by the TH.... Strings?
What happens if they forget to type it or mis-type it?
Where do the users get the TH... Text from?
Is it a cut and paste from another source?
Is it in the database somewhere other than the remarks field?
 
J

JHB

Have been here a while
Local time
Today, 13:37
Joined
Jun 17, 2012
Messages
7,732
luzz, did you read post #14?
 
L

luzz

Registered User.
Local time
Today, 04:37
Joined
Aug 23, 2017
Messages
346
Minty said:
But you said earlier that every remarks field starts with "Reason Stated: ", does this get typed in by the user followed by the TH.... Strings?
What happens if they forget to type it or mis-type it?
Where do the users get the TH... Text from?
Is it a cut and paste from another source?
Is it in the database somewhere other than the remarks field?
Click to expand...

Hmm, this is abit complicated, as the user will type the remarks in the form and get it saved in the database.
This remarks will be keyed in by the user and i have no idea what does TH means as i doing this as a project, but it does not necessary start with TH, But it definitely start with 2 letters.
 
L

luzz

Registered User.
Local time
Today, 04:37
Joined
Aug 23, 2017
Messages
346
JHB said:
If the text in the table shows like you want it, then have you change the property "Text Format" for the control in the report from "Plain text" to "Rich text"?
The interesting thing is not the text you can see, but the characters that are invisible, such as Tabs, Spaces, Return, etc.
It requires you to write some code that analyses the text characters one at a time using their ASCII value.
I you don't know how to do it, post some data in MS-Access database.
Click to expand...

I changed and my remarks turn out this way
 

Attachments

  • Remark rich text.png
    Remark rich text.png
    10.4 KB · Views: 52
J

JHB

Have been here a while
Local time
Today, 13:37
Joined
Jun 17, 2012
Messages
7,732
A last thing, do you've the same text font in the table and at the control in the report.
 
L

luzz

Registered User.
Local time
Today, 04:37
Joined
Aug 23, 2017
Messages
346
JHB said:
A last thing, do you've the same text font in the table and at the control in the report.
Click to expand...

OMG??? I just change the text font in my report to the same as my table and IT WORKS!! Thank you so much!
 
arnelgp

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:37
Joined
May 7, 2009
Messages
19,230
That will do but if you want to change font and make it a little bigger.
 
L

luzz

Registered User.
Local time
Today, 04:37
Joined
Aug 23, 2017
Messages
346
Hi, my remarks managed to align yesterday in my report. However when i print preview report, it does not align again :(
 

Attachments

  • Print preview.png
    Print preview.png
    11 KB · Views: 47
You must log in or register to reply here.

Similar threads

F
How to alignment text on textbox
Replies
11
Views
302
Gasman
Gasman
I
Combo box shows HTML tags
Replies
6
Views
278
ilanray
I
Kayleigh
Report line sizing and textbox alignment
Replies
6
Views
418
Kayleigh
Kayleigh
Z
...but what if???
Replies
13
Views
367
MajP
MajP
N
Align objects in the form to the center w/o using anchoring
Replies
2
Views
350
nax009
N

Users who are viewing this thread

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