473,765 Members | 2,070 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Trouble getting memo field printout exactly the same layout as theform

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
Feb 28 '08 #1
4 1740
Bob Alston wrote:
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
Is it possible you have CanGrow set in the report? If so, set that
property to False.
Feb 28 '08 #2
Salad wrote:
Bob Alston wrote:
>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
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.
Feb 28 '08 #3
Bob Alston wrote:
Salad wrote:
>Bob Alston wrote:
>>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
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.
Feb 29 '08 #4
Bob Alston wrote:
Bob Alston wrote:
>Salad wrote:
>>Bob Alston wrote:

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.

Suggestion s?

Bob

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.
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.
Feb 29 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
8691
by: Alfredo Agosti | last post by:
Hi folks, I have an Access 2000 db with a memo field. Into the memo field I put text with bold attributes, URL etc etc What I need to to is converting the rich text contained into the memo field in plain text. That's because I truncate the string text but if, when I truncate it there's a rich tag the code following the truncated string is corrupted. Don't know if it's clear enough.
5
4718
by: Mike | last post by:
I'm using a script provided by e-mailanywhere, it's a little too big for me. There's 1 text field and 1 password field in a form. OnSubmit, I would like both fields to be validated to look for invalid digits (~`!#$%^&*()+=?/). This is not working yet, I don't know why. In addition, I would like both fields to require from 1 to 12 digits for submition to continue. The text field also Lowers Case, can you tell me how to do the same on...
3
2214
by: Roy Adams | last post by:
Hi I'm reposting this question because for some reason can't post follow up question to this thread. What I'm trying to do is put the value and text from a a select in to a text field and to a hidden field respectfully and the value from dynamically created hidden fiields in to a text fieldin to a text field all at the same time Here's the code as viewed through the browser <body bgcolor="#FFFFFF" text="#000000" > <SCRIPT...
24
2722
by: deko | last post by:
I have an mdb (2002 file format) that uses memo fields extensively. I've read a lot about how problematic memo fields can be and that avoiding them is a good idea. But I'm stuck with them and was wondering if there are any best-parctices for optimizing or mitigating the risk of using them. Here's what one table looks like: NoteText - Memo NoteDate - Date/Time (indexed, dupes ok) NoteBrief - Text (length = 254) Entity_ID - (Long,...
9
5737
by: RMC | last post by:
Hello, I'm looking for a way to parse/format a memo field within a report. The Access 2000 database (application) has an equipment table that holds a memo field. Within the report, the memo field is printed within the detailed area. The problem is, the apllication is not setup properly, thus the users are entering data within the memo field as: location1 1/1/2005 1/1/2006
2
6805
by: Teresa L | last post by:
I am using Access 2003. I have a memo field that I have put into a report. My problem is that the report will only show a specific amount of characters in the report. It does not display the entire field. I have checked the properties and they are set to memo so what is happening here? I think it is happening in more than one field but I have only been able to identify or replicate the problem in one field. Thanks
2
1330
by: DeanL | last post by:
Hi everyone, I hope someone can shed some light on this for me but I seem to be getting problems in an Access 97 DB and need some help on why it's happening and more importantly, how to fix it. Occasionally, one of the memo fields in my DB ends up losing the data contained in it and only contains #Error. When I attempt to go into the field to re-enter the data I get a message stating:
10
3059
by: ARC | last post by:
This is mainly a speed question. In this example: I have a QuotesHdr table that has a few memo fields. If these memo fields are used extensively by some users, and if their are a large number of records in QuotesHdr, should I break out the memo fields into a separate table? The thinking here is that, for Quotes selection dropdowns that display all entries in QuotesHdr for selection, I would think that the entire record comes down over...
8
8745
by: sneddo | last post by:
Ok I am trying to do the above, I have got a script that will restrict the length but it requires the user to enter the field and hit a key, before it will work. This would normaly be find, but the title field gets its information from a previouse page so its value can easily be over 40 chars. (I can not restrict the length on the previouse page.) The major dificulty is that there is no form on the aspx page, and I do not have access to...
0
9398
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
9951
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9832
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7375
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5275
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5419
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3924
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3531
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2805
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.