Problem printing Memo field - Microsoft Access / VBA

John

I have a field, data type Memo, in a job details table. I have a text box on
a report which I need to print the contents of this field. My problem is
that the text box will only display 255 characters. How can I get the report
to print this field completely.

Thanks for any help out there.

John.

Nov 13 '05 #1

Subscribe Reply

3022

Rick Brandt

John wrote:

I have a field, data type Memo, in a job details table. I have a text
box on a report which I need to print the contents of this field. My
problem is that the text box will only display 255 characters. How
can I get the report to print this field completely.

Thanks for any help out there.

John.

Query must not have DISTINCT (at all) or GROUP BY (on the memo field).

Report cannot sort or group on the memo field and cannot have a format
property assigned to the control for the memo field.

Access 97 used to simply disallow these things. In A2K and above they
"improved" it so that is accomodates those things by doing a
Left([FieldName], 255) in the background.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #2

strvariant

"Rick Brandt" <ri*********@ho tmail.com> wrote in news:VVk2e.5218 $yq2.3067
@newssvr12.news .prodigy.com:

John wrote:
I have a field, data type Memo, in a job details table. I have a text
box on a report which I need to print the contents of this field. My
problem is that the text box will only display 255 characters. How
can I get the report to print this field completely.

Thanks for any help out there.

John.

Query must not have DISTINCT (at all) or GROUP BY (on the memo field).

Report cannot sort or group on the memo field and cannot have a format
property assigned to the control for the memo field.

Access 97 used to simply disallow these things. In A2K and above they
"improved" it so that is accomodates those things by doing a
Left([FieldName], 255) in the background.

Sometime ago I was able to successfully group on a memo field in Acc97. I
believe that in the QBE grid you do something like this:

TestField:iif(L en(CStr([MemoField]))=0,"No Text",CStr([MemoField])))

You may need to play around with this but I seem to remember that it
worked. By converting the memo field's value to a string it should allow
the GroupBy to work. Someone else here may be able to verify this?

Hope this helps!

strvariant

Nov 13 '05 #3

John

Thanks for that, I'll check it out.

John

"Rick Brandt" <ri*********@ho tmail.com> wrote in message
news:VV******** *********@newss vr12.news.prodi gy.com...

John wrote:
I have a field, data type Memo, in a job details table. I have a text
box on a report which I need to print the contents of this field. My
problem is that the text box will only display 255 characters. How
can I get the report to print this field completely.

Thanks for any help out there.

John.

Query must not have DISTINCT (at all) or GROUP BY (on the memo field).

Report cannot sort or group on the memo field and cannot have a format
property assigned to the control for the memo field.

Access 97 used to simply disallow these things. In A2K and above they
"improved" it so that is accomodates those things by doing a
Left([FieldName], 255) in the background.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #4

Similar topics

5784

problem displaying MEMO field from ACCESS 2000 on WINDOWS 20003

by: euang | last post by:

Hi, I have been using access 2000 for two years on WINDOWS NT to display dynamic aweb page using ASP My ISP has now changed to Windows 2003, and I am having major problems displaying information from MEMO fields within the Access 2000 database. I have not had any problems before displaying MEMO fields on NT and have tried various tips to resolve this issue but no luck so far. I was wondering if anyone had come accross a similar...

ASP / Active Server Pages

10199

Memo field truncated in query/report?

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.

Microsoft Access / VBA

2804

List Box Problem, - Very Strange.

by: BlackFireNova | last post by:

I am working on an Access 2002 Database. I created a new table and imported some notes data into it from an existing table. Now, when I try to create a List Box, and it displays the list of fields to select from, I can see every field in the new table EXCEPT the VNotes field, (which is the one I imported the existing Notes data into). Can anyone help me understand why the existing text notes could be causing Access to make the field...

Microsoft Access / VBA

5400

Report CAN GROW problem with Memo field

by: Mal | last post by:

I have an ACC 2000 database that has a strange behaviour I have a small table, with just a few fields... My report has very simple grouping and sorting, no code bar a NODATA event. I have a memo field When CAN GROW is set to NO everything works just fine. When CAN GROW is set to YES - watch out.... One record causes BIG

Microsoft Access / VBA

1559

Problem with forms

by: David | last post by:

I have a table which is to hold 70 memo fields to contain notes on data changes to corresponding fields in a form. The problem is I dont want to have to create 70 forms to input notes into. Is it possible to have one form that somehow opens up the correct notes field to input the notes. I was thinking along the lines of having a button against each line of data which then opened this form. Below is the form layout with the notes field...

Microsoft Access / VBA

2161

Problem concatenating memo fields in MS access database

by: ghadley_00 | last post by:

I have an access database form where I have a button that is supposed to be appending the contents of 1 memo field to another is behaving non-predictably. The code is: Me! = Me! & Chr$(13) & Chr$(10) & Me! & Chr$(13) & Chr$(10) & Me! Me! = Me! & Chr$(13) & Chr$(10) & Me! & Chr$(13) & Chr$(10) & Me! DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Microsoft Access / VBA

8155

StreamWriter and BinaryWriter (same problem better explained)

by: philip | last post by:

If I execute that : Dim Temp as string = "This is a text" Dim sw As StreamWriter Dim fullFileName as string = "c:\text.txt" sw = New StreamWriter(fullFilename) sw.Write(temp) sw.Close() the resulting file 'Text.txt' has the same length than the string 'temp'.

Visual Basic .NET

3150

Problem - HUNDREDS of pages blank detail section

by: Mal Reeve | last post by:

Hello, I have a report that has only 2 levels of grouping. The detail section is simply 1 large block for a memo field. I am finding that on some occasions the report errors and generates hundreds (perhaps even an infinite loop...I have to break the system to stop the report generating) of pages. While I'm not 100% I think this may have something to do with the detail

Microsoft Access / VBA

7346

Problem updating memo field with string data from form

by: sara | last post by:

I have a Memo field in a table to hold notes from a conversation a social worker has had with a client (this is for a non-profit). If the user needs to update the memo field, I need to find the original record (which I am doing fine - getting the correct key) and I need to update the "notes" with the new value from the form, which I store in a String Variable. (I've tried storing in a Variant variable; didn't work for me)

Microsoft Access / VBA

8162

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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8605

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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8565

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8246

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 most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

5532

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4045

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

4109

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2550

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

1413

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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General