Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / January 2007

Tip: Looking for answers? Try searching our database.

Uneven text-alignement

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kevin - 02 Jan 2007 12:47 GMT
Hello,

I have a report based on a form with the text-box controls on both being
indentical. The controls on both the report and the form have the same table
as their control source. My problem is that when I update or other wise
change the text-box controls on the form the text doesn't appear on the
report in the same order. As an example, if on the form or in the table I
type:
                           1.Ministry of External Relations
                           2.Ministry of Defence              

then on the report it appears as:

                            1.Ministry of External
                            Relations
                                            2. Ministry of
                             Defence.        

Thus far I've been unable to get the text to appear in the same
text-alignement on both the form and the report. I have the 'can grow' & 'can
shrink' properties for the text box controls on the reprt set to 'yes'. I
have also tried setting the Format properties 'height', 'width' and 'top' for
the text box controls on both the form and the report to indentical values
but with no effect.
I hope my explanation of my problem is clear enough....would anyone know how
I could get the text to appear with the same text-alignement on both the form
and the report?  

Thanks in advance.
John Spencer - 02 Jan 2007 13:07 GMT
Are you typing
 1.Ministry of External Relations                 2.Ministry of Defence
ALL  into one textbox and using spaces to make
 2.Ministry of Defence
appear on a second line?

If so, instead of using spaces to get the second line try typing Control +
return(enter) to embed a new line sequence into the text box.

 1.Ministry of External Relations <<<Control+return>>>2.Ministry of Defence

The next question is why are you putting two (or more) pieces of information
in one field?  I suspect that you may really need to have an additional
table to hold this organization information, but without knowing you
structure I really don't know.

> Hello,
>
[quoted text clipped - 30 lines]
>
> Thanks in advance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.