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 / General 1 / February 2008

Tip: Looking for answers? Try searching our database.

Trouble getting memo field printout exactly the same layout as the form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob Alston - 28 Feb 2008 19:55 GMT
My client insists that the printed copy of text entered into a memo
field have EXACTLY the same layout as it appears on the screen.
I found I had to eliminate the vertical scroll bar.  Then I copied the
memo field from the form to the report.  I verified that the font and
font size (MS Sans serif 8) were the same.  However, the text shows
differently.  On the printed version, more text shows on the line than
in the form.

Suggestions?

Bob
Salad - 28 Feb 2008 21:59 GMT
> My client insists that the printed copy of text entered into a memo
> field have EXACTLY the same layout as it appears on the screen.
[quoted text clipped - 7 lines]
>
> Bob
Is it possible you have CanGrow set in the report?  If so, set that
property to False.
Bob Alston - 28 Feb 2008 23:06 GMT
>> My client insists that the printed copy of text entered into a memo
>> field have EXACTLY the same layout as it appears on the screen.
[quoted text clipped - 9 lines]
> Is it possible you have CanGrow set in the report?  If so, set that
> property to False.
But that wouldn't change the layout of text left to right.
Bob Alston - 29 Feb 2008 20:28 GMT
>>> My client insists that the printed copy of text entered into a memo
>>> field have EXACTLY the same layout as it appears on the screen.
[quoted text clipped - 10 lines]
>> property to False.
> But that wouldn't change the layout of text left to right.
Salad - 29 Feb 2008 21:35 GMT
>>>> My client insists that the printed copy of text entered into a memo
>>>> field have EXACTLY the same layout as it appears on the screen.
[quoted text clipped - 12 lines]
>>
>> But that wouldn't change the layout of text left to right.

I copied a field on a form that was a memo to a report and plugged in a
bunch of nonsense into the memo field.  When the size of the boxes were
the same I was able to display more data in the report's memo even tho
they were the same size.  So I needed to shrink the size of the memo in
the report and finally got them to display the same data.

So the only thing I can think of is to make the report's memo a tad bid
smaller.
 
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.