Hi everyone,
I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page breaks.
In other words, if my memo field is 3 paragraphs long and there
is only space on a report page for 2 paragraphs, rather than
putting 2 paragraphs on one page and the last one on the next
page, all 3 paragraphs are moved to the next page (which creates
a lot of wasted white space on the first page!). I assume
Access does this because it sees the entire memo field as a
'cell' that cannot be split up.
Does anyone have any idea how I can enable Access to split my
memo fields to conform with page lengths? Would using the Split
function work in this case?
Thank you in advance for your help! 4 3602
I don't think that the Split function would help, as that just breaks
a string into an array based on how a delimter, like a space.
My recommendation to you is to use Word as your report writer in this
case, as it will handle paragraphs better than an Access report.
Chris
On Jul 16, 1:45 pm, kaplan.gill...@ gmail.com wrote:
Hi everyone,
I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page breaks.
In other words, if my memo field is 3 paragraphs long and there
is only space on a report page for 2 paragraphs, rather than
putting 2 paragraphs on one page and the last one on the next
page, all 3 paragraphs are moved to the next page (which creates
a lot of wasted white space on the first page!). I assume
Access does this because it sees the entire memo field as a
'cell' that cannot be split up.
Does anyone have any idea how I can enable Access to split my
memo fields to conform with page lengths? Would using the Split
function work in this case?
Thank you in advance for your help!
You could try setting the Keep Together property of the section that
contains the memo field.
Setting it to No might allow Access to print whatever fits on the page. No
guarantee that it will break at a paragraph break (if that matters.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<ka************ @gmail.comwrote in message
news:11******** **************@ d55g2000hsg.goo glegroups.com.. .
Hi everyone,
I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page breaks.
In other words, if my memo field is 3 paragraphs long and there
is only space on a report page for 2 paragraphs, rather than
putting 2 paragraphs on one page and the last one on the next
page, all 3 paragraphs are moved to the next page (which creates
a lot of wasted white space on the first page!). I assume
Access does this because it sees the entire memo field as a
'cell' that cannot be split up.
Does anyone have any idea how I can enable Access to split my
memo fields to conform with page lengths? Would using the Split
function work in this case?
Thank you in advance for your help!
ka************@ gmail.com wrote in news:1184615108 .138313.129120
@d55g2000hsg.go oglegroups.com:
Hi everyone,
I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page
breaks.
In other words, if my memo field is 3 paragraphs long and
there
is only space on a report page for 2 paragraphs, rather than
putting 2 paragraphs on one page and the last one on the next
page, all 3 paragraphs are moved to the next page (which
creates
a lot of wasted white space on the first page!). I assume
Access does this because it sees the entire memo field as a
'cell' that cannot be split up.
Does anyone have any idea how I can enable Access to split my
memo fields to conform with page lengths? Would using the
Split
function work in this case?
Thank you in advance for your help!
Set the 'Keep Together' property of the section (presumably the
detail section,to No.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
"ch************ @gmail.com" <ch************ @gmail.comwrote in
news:11******** **************@ j4g2000prf.goog legroups.com:
I don't think that the Split function would help, as that just
breaks a string into an array based on how a delimter, like a
space.
My recommendation to you is to use Word as your report writer
in this case, as it will handle paragraphs better than an
Access report.
Chris
On Jul 16, 1:45 pm, kaplan.gill...@ gmail.com wrote:
>Hi everyone,
I currently have an Access database that includes quite a few long memo fields. When I create a report of my data, Access does not allow the memo fields to be split with the page breaks. In other words, if my memo field is 3 paragraphs long and there is only space on a report page for 2 paragraphs, rather than putting 2 paragraphs on one page and the last one on the next page, all 3 paragraphs are moved to the next page (which creates a lot of wasted white space on the first page!). I assume Access does this because it sees the entire memo field as a 'cell' that cannot be split up.
Does anyone have any idea how I can enable Access to split my memo fields to conform with page lengths? Would using the Split function work in this case?
Thank you in advance for your help!
Set the 'Keep Together' property for the report band (I presume
Detail) to No.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jeremy |
last post by:
I have a pretty straightforward database that is designed to record
free-form information about products (date, source and a memo field).
This is searched and updated via a form. For new records, the memo
field is usually filled by cutting and pasting from e-mails, web
content and spreadsheets.
The only problem is that some of the memos can be just a few words,
and some can be tens or hundreds of lines, and I've realised that
zooming...
|
by: GorDon |
last post by:
Hi,
I have a report based on a query. The query grabs a memo field from
my main table, yet when I display the memo field in the report it
truncates the memo field (the field needs to hold more than 255
characters). The table holds all the memo text, but the query seems
to truncate the memo field to 255 chars?
This seems like there should be a relatively easy fix, but I can't
seem to find it.
|
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
|
by: Roy |
last post by:
Hi All,
I have a table in A2K application.I get a memo field via download from
a .csv file.The contents are as below:
field name is TicketStatus,
For example,a single ticket,TicketID 12345 has a track history
contained in TicketStatus field.It starts right from problem opened
until problem closed with date/time.
|
by: Roy |
last post by:
I have a table with two fields. I wish to separate all the data in
one field and keep it listed against the information in the other
field. The information within the field TicketStatus, I wish to
separate is
separated with a small box, meaning a tab .There can be up
to twenty separate bits of info in the field.
I would like to get a table in which the information in the field I
am trying to separate (TicketStatus),is individually listed...
| |
by: AccessThis |
last post by:
Hi everyone,
I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page breaks.
In other words, if my memo field is 3 paragraphs long and there
is only space on a report page for 2 paragraphs, rather than
putting 2 paragraphs on one page and the last one on the next
page, all 3 paragraphs are moved to the next...
|
by: Roger |
last post by:
I've got two tables in sql2005 which have an 'ntext' field
when I linked the first table in access97 last week using an odbc data
source the access-field type was 'memo'
when I link the 2nd table today, it is linked as a text(255) field,
ditto for the first table if I link it today
if I link the 2nd table using access2003 (and the same odbc data
source) it is linked as a memo field
|
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...
|
by: AdrianJ1980 |
last post by:
Hi,
I apologise for not providing a code basis for my question, but i really am stuck.
Does anyone know how i can split a memo field, such as below, into separate records. (The data comes from the body of daily system generated emails that the database is linked to)
Single Field:
AUS 123 $450 $396 -4 N
AUS 456 $2560 $2860 300 N
AUS 789 $987 $2 -985 P
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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
| |
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...
| |