Missing text from memo field - Microsoft Access / VBA

Teresa L

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

Feb 7 '07 #1

Subscribe Reply

6778

Tim Marshall

Teresa L wrote:

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.

By the sounds of it, there is more text in the memo field of the
record(s) in question than there is space in the control you have set up
in your report. The solution is pretty straightforward .

Assuming your memo fild report text box control is in a detail section,
you need to select the detail section bar and in the detail properties
under the format tab, set "CanGrow" to Yes. You must then ensure you do
the same thing to the Can Grow property of the text box.

You may also wish to consider setting Can shrink to yes as well,
depending on your report layout requirements.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me

Feb 7 '07 #2

Jens Schilling

Hi,

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.

In addition to what Tim wrote - if your report is based on a query, it's
really possible that your memo field is truncated after 255 characters. This
is often caused by a group statement within a query ( Group by, distinct) -
or by a formatted memo field, as you can read here :

http://support.microsoft.com/kb/259893/en-us

The solution could be to delete the memo field in your original query,
create a second query only containing your ID and the memo field, and
combine it in a third query.

Regards
Jens

Feb 7 '07 #3

Similar topics

8647

Content from a memo field: converting the rich text into plain text

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...

ASP / Active Server Pages

10444

Copy/Print text form memo field?

by: Shyguy | last post by:

I want to create two buttons on a form. One would allow the user to Copy the contents of the current records memo field, the other would allow them to print. I set up a report based on the memo field, and it works. But, it seems wrong since I had to create a huge text box to accommodate memo fields with a lot of text. Thanks for any help,...

Microsoft Access / VBA

2485

Checking for Text & Moving to the end of a Memo Field

by: PMB | last post by:

Thank you in advance for any and all assistance. I'm trying to input data from strings to a memo field. I would like to know how to check first to see if there is text there currently and if so move to the end and input the new text. Also, would like to know if I can change the justification on each line of text as it's entered. i.e. ...

Microsoft Access / VBA

2493

no format assignment for a form's textbox control... Access assumes control's data is going to be placed in a finite length text field of a table

by: MLH | last post by:

I have a form with two controls: !! - combo box !! - text box A button on the form tries to run this SQL when clicked... INSERT INTO BodyMsgsSent (ToWhom, BodyText) SELECT DISTINCTROW !! AS MyTargets, !! AS MyList; When the SQL runs, it fails with msg saying "Field length is too

Microsoft Access / VBA

1369

Please help! A2K Memo field showing error "Too much text to edit"

by: Lauren Wilson | last post by:

The error does not have an error number. It's not even a normal Access error message box. Hope someone has some insight to this problem. I have a form that contains a large (5" x 4") text box bound to a memo field. This field allows users to type in the text of an email to be sent through Outlook (via automation). I ONE user who send...

Microsoft Access / VBA

377

Display of text fields

by: Ennio-Sr | last post by:

Hi all! After a very long struggle I finally succeded in transferring my old *.dbf file and the relating *.dbt (alias memo fields) to a pg table. For the time being I put the memo field in a separate table having two fields only (i.e.: n_memo integer, memo text) which can be related to the main table in a view.

PostgreSQL Database

3015

Pasting 1st line of memo field to a text field (revisited)

by: alexsg | last post by:

A little while ago Ron P kindly responded to my inquiry on how to copy the first line of memo field into a text field, using a query: left(,instr(1,,vbCrLf)-1) This is great, but I would like to do this on a form, so that the person entering the memo can use a button to paste the 1st line to a title (text) field. I'm having trouble...

Microsoft Access / VBA

3367

access97, sql2005 memo field in a linked table shows as a text field

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...

Microsoft Access / VBA

4336

How to change text to memo

by: barbara_dave | last post by:

Hi all, I want to change a field data type from Text to Memo.The reason is I need to type more text in that field. when I was saving the change I got error message "The width of a Unicode text column must be an even number of bytes." Could some one tell me what I can do with this message and how I can change the existing text field to...

Microsoft Access / VBA

7468

What is ONU?

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...

General

7656

Problem With Comparison Operator <=> in G++

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. ...

C / C++

7423

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

7757

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

5972

AI Job Threat for Devs

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...

Career Advice

5329

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

1884

transfer the data from one system to another through ip address

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

C# / C Sharp

1014

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

704

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General